Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nithin_miryala
Contributor

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

Re: Set Analysis not working

How about this

ProvEst_CreatYearMonth = {'$(=vPreviousMonth)'}

7 Replies
atkinsow
Valued Contributor II

Re: Set Analysis not working

Try it without the $

nithin_miryala
Contributor

Re: Set Analysis not working

In set analysis can we equate with expression without $?

YoussefBelloum
Esteemed Contributor

Re: Set Analysis not working

Hi,

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

nithin_miryala
Contributor

Re: Set Analysis not working

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

Re: Set Analysis not working

How about this

ProvEst_CreatYearMonth = {'$(=vPreviousMonth)'}

nithin_miryala
Contributor

Re: Set Analysis not working

Its still not working

Capture.PNG

Re: Set Analysis not working

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

=vPreviousMonth

Community Browser