topic Problem with Date Timestamp in App Development

Problem with Date Timestamp

50ShadesOfSalty — Sat, 16 Nov 2024 05:42:04 GMT

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 — Thu, 30 May 2019 16:57:11 GMT

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 — Thu, 30 May 2019 22:07:55 GMT

Hello,

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

cordially.