Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.