Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
natisham
Contributor II
Contributor II

Use a Different date

how would i go about having a different date within an expression.

My table has a created date and closed date. I can count open cases with the created date linked to my calendar but within the same Straight chart I would like to count the closed cases within the same month for Case Count using ClosedDate.

Capture.PNG

Labels (1)
5 Replies
vishsaggi
Champion III
Champion III

Can you share a snapshot of your data model?

natisham
Contributor II
Contributor II
Author

Capture.PNG

vishsaggi
Champion III
Champion III

No not this. When you press Ctrl+T you can see the data model, can you take snapshot of that and paste here pls?

natisham
Contributor II
Contributor II
Author

We have alot in this QVD- for the question i use only one table.

vishsaggi
Champion III
Champion III

You might have to load the calender script again for your closed dates.

Read Here.

Why You sometimes should Load a Master Table several times