Qliksense variable

[yogitamehta10]

i have defined a variable in variable field

where  it says

name:vmaxmonthyear

defination:max(Date#([MONTH YEAR Calender]))

how can i use this in set anyalysis

Count({<[Calender MONTH]={"$(vMaxMonthYear)", >}[TXN UID])

[sunny_talwar]

May be like this:

Count({<[Calender MONTH]={"$(=vMaxMonthYear)"}>}[TXN UID])

or

Count({<[Calender MONTH]={"$(=$(vMaxMonthYear))"}>}[TXN UID])

[santiago_respane]

Hi,

i think you only need to add the = sign as follows:

=Count({<[Calender MONTH]={"$(=vMaxMonthYear)", >}[TXN UID])

Please let me know if it helps.

Kind regards,

[yogitamehta10]

This is not working ,

Actually i have calculate maximum year and month , so that i cna show the latest month data .

My month-year column is like this

MMM-YYYY

i'm using variable

max(Date#([MONTHYEARCalender]))

Do you think this right???

[yogitamehta10]

This is not working ,

Actually i have calculate maximum year and month , so that i cna show the latest month data .

My month-year column is like this

MMM-YYYY

i'm using variable

max(Date#([MONTHYEARCalender]))

Do you think this right???

[yogitamehta10]

Plaese help

[santiago_respane]

Hi Yogita,

what do you mean by not working?

Not giving the desired result? Returning Error in Expression?

Maybe you can share a sample app in order to give a more effective solution.

Kind regards,