topic Year to Year with Set Analysis in QlikView

Year to Year with Set Analysis

Fri, 24 Feb 2017 10:11:09 GMT

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:

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

sunny_talwar — Fri, 24 Feb 2017 10:24:53 GMT

May be try this:

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

Assuming T0 is formatted as DD/MM/YYYY

sasikanth — Fri, 24 Feb 2017 10:26:16 GMT

Could you pleas share that excel file ?

Fri, 24 Feb 2017 10:30:51 GMT

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

sunny_talwar — Fri, 24 Feb 2017 10:33:46 GMT

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)

Fri, 24 Feb 2017 10:34:25 GMT

Here is the excel file

Fri, 24 Feb 2017 10:38:10 GMT

Due to the sign expansion Many Thanks Sunny