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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selecting data between dates

Hello there,

I've several tables which contains datetime columns. The idea is being able to sort by month for example considering those columns.

I've read about creating the master calendar and other stuff but I can't make it to work. I don't know where to make the join between the "selection" and the column.

I've imported the master calendar from this URL:

My new and improved Calendar in QlikView 9 | Rhyous

But coming to practice, I've created a chart where the dimension is the CalendarMonthName and the expression a count of IDs, and a count of actions performed. The idea is be able to count how many ID where created and how many actions where performed in a month based in the CalendarMonthName.

I simply don't understand how to tell Qlikview to just cound the ID based in the "month range" selected.

Hope that this makes any sense.

2 Replies
Not applicable
Author

Hi Neo,

Could you please attach your qvw here?

Thanks

Sabal

israrkhan
Specialist II
Specialist II

i think you need to see this video...

Selecting Arbitrary Date Ranges