Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
nirav_bhimani
Partner
Partner

Set Analysis Help

Hi Everyone,

Following is my Pivot table in that I want to calculate the time difference bet each event. I have used the interval() and above() fuction to get the output, It works if i take only one dimension i.e.event, If I add more dimension then my expression doesnt work.

if(RowNo(TOTAL)=1,null(), Interval(Timestamp(EVENT_DATE) - Timestamp(Above(EVENT_DATE)),'d hh:mm'))

Container NumberEVENTEVENT_DATE
AA105-12-2012 13:56
AA205-12-2012 21:59
AA305-12-2012 04:30
AA404-12-2012 21:00
AA505-12-2012 02:00
AA605-12-2012 20:58
AA705-12-2012 14:15
AA811-12-2012 06:59
AA906-12-2012 11:00
AA1006-12-2012 11:01
AA1105-12-2012 12:56
AA1205-12-2012 06:05
AA1305-12-2012 03:30
AA1405-12-2012 06:00
AA1519-12-2012 05:36
AA1607-12-2012 16:00
AA1705-12-2012 04:40
AA1805-12-2012 12:47
AA1920-12-2012 05:37
AA2009-12-2012 13:35
AA2107-12-2012 16:30
AA2209-12-2012 16:11



Please help me.

Thanks & Regards,

Nirav Bhimani

1 Solution

Accepted Solutions
Gysbert_Wassenaar

If you have more than one dimension use the total keyword in the above function.

You could also try calculating the time between events in the script, but it's unclear to me what the order of the events is. The event dates certainly aren't chronological.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
shaik_basha
Creator III
Creator III

hi,

    Please check the application,problem is above function is work only for in report minimun two dimensions are needed.

Regards

Gysbert_Wassenaar

If you have more than one dimension use the total keyword in the above function.

You could also try calculating the time between events in the script, but it's unclear to me what the order of the events is. The event dates certainly aren't chronological.


talk is cheap, supply exceeds demand
Oleg_Troyansky

try using a prefix TOTAL within your function above(), most likely you are getting the wrong results because of the second dimension.

nirav_bhimani
Partner
Partner
Author

Hi everyone,

Thanks for your help, I need further help. I am getting the date difference in days but my problem is when the container is different then it should not take the last date of previous container for a diffrence. Is it possible with set analysis expression?

Thanks & regards,

NIrav Bhimani