Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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)

Not applicable
Author

Here is the excel file

Not applicable
Author

Due to the sign expansion Many Thanks Sunny