This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
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?
View solution in original post
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
have generated two columns based on canonical date. I have taken them as a table in Chart.
Appt Date Date Entered
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.
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
In the measure . go to totals function and make it Sum