Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qvc.qvs : Common Calendar issue

Hi,

I have this data(attached). It has multiple dates viz., [Open Time], [Resolved Time], and [Closed Time]. Whenever [Closed Time] is null, [Resolved Time] is considered as [Closed Time]. All are dates actually.

The requirement is that, whenever a day is selected, the number of calls logged on that day( count of open calls) and the number of calls closed on that day is to be displayed. Similarly, for any period selected, the charts should behave accordingly.

I have tried with both the functions with date variables and   from_field , as per suggestions in the qvc.qvs forum.

Have attached the data and working stuff here.

Any suggestions, how this can be achieved?

Thanks,

-knightrider

accordingly
0 Replies