Generating Calendar for seeing matching dates

[kaustubh]

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?

[dplr-rn]

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

[kaustubh]

 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.

[dplr-rn · Accepted solution]

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

[kaustubh]

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

[dplr-rn]

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

[kaustubh]

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 !!