topic Re: Set Analysis not working in QlikView

Set Analysis not working

nithin_miryala — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Here is my expression

It was working fine until i add the PreviousMonth variable in there.

PreviousMonth= Oct 2017

For some reason when i do $(vPreviousMonth) then result is ).

That the reason its not equating to the MonthYear Field.

Any thoughts? Is my expression correct.

i just want to filter the data to be to last Month

Thanks

Nithin

Anonymous — Fri, 03 Nov 2017 15:17:18 GMT

Try it without the $

nithin_miryala — Fri, 03 Nov 2017 15:19:22 GMT

In set analysis can we equate with expression without $?

YoussefBelloum — Fri, 03 Nov 2017 15:31:06 GMT

Hi,

check if the date format are the same in the variable and in the dimension.

nithin_miryala — Fri, 03 Nov 2017 15:55:13 GMT

Formats are perfect but. i tried equating out side with just if case and it worked. Its not working Set analysis

sunny_talwar — Fri, 03 Nov 2017 15:56:11 GMT

How about this

ProvEst_CreatYearMonth = {'$(=vPreviousMonth)'}

nithin_miryala — Fri, 03 Nov 2017 16:13:12 GMT

Its still not working

sunny_talwar — Fri, 03 Nov 2017 16:15:00 GMT

What do you get when you use this in a text box object? (without dollar sign expansion)

=vPreviousMonth