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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Start date and end date of the current selected period

Hi everyone:

This is my first post and I am new to Qlikview.

I hope that I can get some help for my problem.

How do I know the start date and end date of the current selected period (selection in a calendar list box)?

Thank you very much.

PC

10 Replies
Not applicable
Author

I got this. The point was to get a count of clients registered in a given year.

I had to use set-analysis "inside" set-analysis. The expression is like

=count({<CLIENT_CreationDate = {">=$(=min({<Year= {'$(=max(Year))'} >} Date))  <= $(=max({<Year= {'$(=max(Year))'} >} Date))"} >} Client)

counting clients where ClientCreationDate is greater than the minimum date for the given Year AND lesser than the maximum date for the given year.

And... for the GivenYear-1 Compairison, I use this one:

=count({<CLIENT_CreationDate = {">=$(=min({<Year= {'$(=max(Year)-1)'} >} Date))  <= $(=max({<Year= {'$(=max(Year)-1)'} >} Date))"} >} Client).

Feel free to comment anyway. It can only be beneficial for everyone.