Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivotable with count max, min, avg between date



Hi all Pro´s!

I´m with serious doubts about create a pivotable to show some data..

1) I need show the quantity of calls for each hour per day( user must select the period) ex. start 18/01/2010, end 22/01/2010 (1 week).

The user must select the hour period for ex 08:00 - 19:59.

2) The pivot table must show the COUNT of call for the period selected by day/hour, MAX calls for week selected(wich hour of wich day is '>' ), MIN calls for week selected(wich hour of wich day is '<' ) and AVG.

for + details please see the exaple:

error loading image

****** the dates are fulldatetime dd/mm/yyy hh:mm:ss

It´s no necessary be with this apparence, but I must show these data.

someone can help me please?

Sorry by english errors... I´m a brasilian guy tring learn it!

0 Replies