Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nithin_miryala
Creator
Creator

Set Analysis not working

Hi All,

Here is my expression

WhatsApp Image 2017-11-03 at 9.48.32 AM.jpeg

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 ).

Capture.PNG

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

1 Solution

Accepted Solutions
sunny_talwar

How about this

ProvEst_CreatYearMonth = {'$(=vPreviousMonth)'}

View solution in original post

7 Replies
Anonymous
Not applicable

Try it without the $

nithin_miryala
Creator
Creator
Author

In set analysis can we equate with expression without $?

YoussefBelloum
Champion
Champion

Hi,

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

nithin_miryala
Creator
Creator
Author

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

sunny_talwar

How about this

ProvEst_CreatYearMonth = {'$(=vPreviousMonth)'}

nithin_miryala
Creator
Creator
Author

Its still not working

Capture.PNG

sunny_talwar

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

=vPreviousMonth