Solved: Qlik Sense November 2018 Issues/bugs in Set Analay... - Qlik Community

dilipkumard13 · ‎2019-02-12

In Previous Versions of Qlik sense June 2018 it was working Fine.

Now i upgraded Qlik sense November 2018.

Below expression is not working.

[Year-Month]*={'>=$(=Monthstart((vMay)))'}

Please Suggest

sunny_talwar · ‎2019-02-13

Try setting your variable like this

LET vMay = Num(MakeDate(2018, 5));

and then use it like this

[Year-Month] *= {">=$(=Date($(vMay), 'MMM-YY'))"}

or this

[Year-Month] *= {">=$(=Date(vMay, 'MMM-YY'))"}

pradosh_thakur · ‎2019-02-12

Try
[Year-Month]*={">=$(=Monthstart((vMay)))"}

Learning never stops.

dilipkumard13 · ‎2019-02-12

Thank you Pradosh. i tried but not working with double quotes.

pradosh_thakur · ‎2019-02-12

Try
[Year-Month]*={">=$(=Monthstart(vMay))"}

How does vMay looks like , does it include a = or not ?

@sunny_talwar may help if the above doesn't work.

Learning never stops.

dilipkumard13 · ‎2019-02-12

Let vMay=Date('01-05-2018','MMM-YY')

sunny_talwar · ‎2019-02-12

May be try this

Let vMay = Date(MakeDate(2018, 5),'MMM-YY')

dilipkumard13 · ‎2019-02-12

Dear Sunny,

Thank you, I tried above exp. its not working.

sunny_talwar · ‎2019-02-12

What format is [Year-Month] in?

dilipkumard13 · ‎2019-02-12

date(monthstart([Completed Date]), 'MMM-YY') AS "Year-Month"

sunny_talwar · ‎2019-02-12

Can you try this

[Year-Month] *= {">=$(=Date(MakeDate(2018, 5), 'MMM-YY'))"}

We can fix the variable once we have this working

Qlik Sense November 2018 Issues/bugs in Set Analaysis