Problem with Date Timestamp

[50ShadesOfSalty]

Hello everyone,

I'm developing a set analysis condition to filter only 3 months.

For it, i have 2 variables:

$(v1) = Max(Date(AddMonths(Date,-6), 'MMM YY')), output: Dec 18

$(v2) = Max(Date(AddMonths(Date,-12), 'MMM YY')), output: Jun 18.

However, when i try to create a set analysis with both that conditions, it gets me a error.

Set analysis: Count({< [Date]={">=$(=v2) <=$(=v1)"} >} [Measure])

Can anyone help me with this?

[Lauri]

Try putting the equal sign into your variable definition, like:

=Max(Date(AddMonths(Date,-6), 'MMM YY'))

And then maybe remove it from the set analysis, like:

Count({< [Date]={">=$(v2) <=$(v1)"} >} [Measure])

Or your variable may need to be a full date, not MMM YY -- I wonder if Qlik sees the variable as text rather than date.

=Date(Max(AddMonths(Date,-6)))

[Seyko]

Hello,

Try this expression: Count({< [Date]={">=$(=$(v2)) <=$(=$(v1))"} >} [Measure])

cordially.