topic Expression Label not displaying correctly in QlikView

Expression Label not displaying correctly

Tue, 16 Sep 2014 12:53:49 GMT

Calendar Month	Year-Period	Financial Year	Financial Period	Month	Period-Month	Month Index
Jan-14	2014-9	2014	9	Jan	9 - Jan	24177
Feb-14	2014-10	2014	10	Feb	10 - Feb	24178
Mar-14	2014-11	2014	11	Mar	11 - Mar	24179
Apr-14	2014-12	2014	12	Apr	12 - Apr	24180
May-14	2015-1	2015	1	May	1 - May	24181
Jun-14	2015-2	2015	2	Jun	2 - Jun	24182
Jul-14	2015-3	2015	3	Jul	3 - Jul	24183
Aug-14	2015-4	2015	4	Aug	4 - Aug	24184
Sep-14	2015-5	2015	5	Sep	5 - Sep	24185
Oct-14	2015-6	2015	6	Oct	6 - Oct	24186
Nov-14	2015-7	2015	7	Nov	7 - Nov	24187
Dec-14	2015-8	2015	8	Dec	8 - Dec	24188

In the table above , I have Calendar Month linked to our financial year and period. The month index is calculated by taken Financial Year x 12 + Financial Period. So for eg, Sept 14 , the month index = (2015 x 12) + 5 = 24185.

In my variable overview , i have created a max (MonthIndex) and called it vMaxMI. In my expression label, if i say =vMaxMI, then the result is 24185. However, if i want to display the Calendar Month (ie Sept 14), I have tried :

if ([Month Index] = vMaxMI, [Calendar Month]) , but this does not work. I have tried several other variations, but still no success.

Please can you help.

Thanks

kind regards

Nayan

Re: Expression Label not displaying correctly

Anonymous — Tue, 16 Sep 2014 12:59:49 GMT

Change vMaxMI to $(vMaxMI) in your expression

Re: Expression Label not displaying correctly

senpradip007 — Tue, 16 Sep 2014 13:07:06 GMT

Use $(vMaxMI)

Re: Expression Label not displaying correctly

Tue, 16 Sep 2014 14:48:47 GMT

Hi Konstantins

I have tried it, but i get a blank result. below is the formula i changed where i added the $ sign.

=if(MonthIndex, $(vMaxMI), [Calendar Month])

kind regards

Nayan

Re: Expression Label not displaying correctly

Tue, 16 Sep 2014 15:14:25 GMT

An error on my side, in the formula, i mistakenly subsituted a 'comma' for the 'equals to' . The formula works

Thank you

kind regards

Nayan