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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.