Qlikview / Qliksense Formulas Formatting Dates & Times

Format DateTime as Time Bucketed into 30 Minute Intervals ( 2 Buckets per Hour)

= Time(Timestamp(round(eventtime, (1/(24*2)))))

Qlikview Display Time in 30 Minute Intervals

Format DateTime as Time Bucketed into 15 Minute Intervals ( 4 Buckets per Hour)

= Time(Timestamp(round(eventtime, (1/(24*4)))))

 

Using Set Analysis To Count Only Page Views Not Page Events (ClickStream Data Processing)

=COUNT({<udo_event_type={"pageview"}>}eventid)

 

Do Easy Year over Year Comparisons By Separating Year from MM/DD (YOY)

=Right('00' & Text(Num(month(calendar_date))),2) & ' / ' & Right('00' & Text(Day(calendar_date)),2)

 

Format Number as Percentage:

= NUM(value, '#,###.#%')