Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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