Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jgqliksense
New Contributor

How to get chart with measure by two dates from one table

Hello,

     I have one table where is ticket id, receive_date, resolve_date. Now i want to make chart with

          X axis - period date from master calendar.

          Y axis -      1 line count of receive tickets

                            2 line count of resolve tickets

QlikDiscusion 1.PNG

     How i can achieve it?

Tags (1)
2 Replies

Re: How to get chart with measure by two dates from one table

Look into creating a Canonical Date

zebhashmi
Valued Contributor

Re: How to get chart with measure by two dates from one table

i don't think it will help but maybe you can find some way from it

Capture.PNG

if(ValueList('A','B','C')='A',Count({<rdate={'01/01/2018'}>}rdate),if(ValueList('A','B','C')='B',Count({<rdate={'01/15/2018'}>}rdate),Count({<rdate={'01/30/2018'}>}rdate)))

Community Browser