Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Not applicable

Qvc.qvs : Common Calendar issue


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?



Tags (2)