topic Re: Generating Calendar for seeing matching dates in App Development

Generating Calendar for seeing matching dates

kaustubh — Wed, 23 Jan 2019 19:53:39 GMT

I wish to generate a calendar based on two columns in my DB . "date _entered" and "appt_date". I have to generate it in the manner where "appointment date" and "date entered" are comparable and a boolean is generated when they are same.

Can someone please suggest something?

Re: Generating Calendar for seeing matching dates

dplr-rn — Wed, 23 Jan 2019 19:31:41 GMT

not sure what you mean by

"generate it in the manner where "appointment date" and "date entered" are same."

Generally when there are 2 dates involved i would recommend a canonical date. check below link

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Re: Generating Calendar for seeing matching dates

kaustubh — Wed, 23 Jan 2019 21:04:34 GMT

have generated two columns based on canonical date. I have taken them as a table in Chart.

Example:s

Appt Date Date Entered

2016-01-04 2016-01-04

2016-01-05 2016-01-02

2016-01-02 2016-01-02

No I need a third column or boolean and then add all the '1s'

The 1s will be generated when the value of dates in both "Appt Date" and "Date Entered" match.

Ex the 1st and 3rd entry in above table example has the same dates. i need a 1 to be generated against it.

Re: Generating Calendar for seeing matching dates

dplr-rn — Wed, 23 Jan 2019 21:10:24 GMT

try with a measure like below
if (Only([Appt Date])=Only([Date Entered]), 1,0)

Re: Generating Calendar for seeing matching dates

kaustubh — Wed, 23 Jan 2019 21:16:51 GMT

Yes Thank you for prompt response. I did try it and I got table like this on my dashboard.

Now I wish to sum the 1s to see total of these same date records. I have never worked with tables on the dashboard of Qlik. So I do not know how can I select the Boolean column of this tables

Re: Generating Calendar for seeing matching dates

dplr-rn — Wed, 23 Jan 2019 21:21:21 GMT

In the measure . go to totals function and make it Sum

Re: Generating Calendar for seeing matching dates

kaustubh — Wed, 23 Jan 2019 21:59:59 GMT

Thank you very much Mahn. I just feel embarassed on how foolish my questions were. Sorry to bother you but I am new to this software.

Please take care. Thanks once again !!