topic Re: Qliksense variable in QlikView

Qliksense variable

yogitamehta10 — Wed, 31 Aug 2016 17:14:32 GMT

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 — Wed, 31 Aug 2016 17:16:43 GMT

May be like this:

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

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

santiago_respane — Wed, 31 Aug 2016 17:17:41 GMT

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 — Wed, 31 Aug 2016 17:43:29 GMT

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 — Wed, 31 Aug 2016 17:43:39 GMT

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 — Wed, 31 Aug 2016 18:01:43 GMT

Plaese help

santiago_respane — Wed, 31 Aug 2016 18:20:11 GMT

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,