Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Year to Year with Set Analysis

Hi all,

I need to count the record created during the year to year period regarding a date in different fields

To to so I created in the loading script a var :

SET vYearToYear = AddYears(Today(),-1);

In my table I have something like:

   

IdRecordT-1T0T1T2T3T4T5T6
1 14/02/201714/02/2017
217/04/201514/02/2017
312/05/2016 07/02/2017
411/07/201620/09/2016 07/02/2017
511/07/201620/09/2016 07/02/2017
613/10/201613/12/2016 07/02/2017
725/08/201425/03/201516/02/201613/12/201607/02/2017
805/11/201615/12/2016 07/02/2017
929/05/201523/05/2016 07/02/2017
1026/11/201525/01/2017
1124/01/2017
1201/12/201219/01/201610/01/2017
1314/04/201630/08/201610/01/2017
1401/09/201512/04/2016N/AN/A10/01/2017

Finally I need to get in textboxes the number to [T-1] that hapened during the year to year period, the same for [T0] and so on.

I tried :

Count({$<[T0]={">=$(=vYearToYear)"}>}IdRecord)

It give me 0 for [T-1] when it should be 7

1 Solution

Accepted Solutions
sunny_talwar

What does this give you in a text box?

=Date(vYearToYear, 'DD/MM/YYYY')

May be use dollar sign expansion

Count({$<[T0]={">=$(=Date($(vYearToYear), 'DD/MM/YYYY'))"}>}IdRecord)

View solution in original post

6 Replies
sunny_talwar

May be try this:

Count({$<[T0]={">=$(=Date(vYearToYear, 'DD/MM/YYYY'))"}>}IdRecord)

Assuming T0 is formatted as DD/MM/YYYY

sasikanth
Master
Master

Could you pleas share that excel file ?

Not applicable
Author

Thanks Sunny the date is formated DD/MM/YYYY but still have 0 as the answer

sunny_talwar

What does this give you in a text box?

=Date(vYearToYear, 'DD/MM/YYYY')

May be use dollar sign expansion

Count({$<[T0]={">=$(=Date($(vYearToYear), 'DD/MM/YYYY'))"}>}IdRecord)

View solution in original post

Not applicable
Author

Here is the excel file

Not applicable
Author

Due to the sign expansion Many Thanks Sunny