topic Re: month variable not working For all months i got the same results in QlikView

month i got the same results

NavinReddy — Fri, 18 Mar 2016 13:08:17 GMT

!Dear Experts,

Please help me below if condition i'm not getting exact Month selection filters

for all the months i'm getting exact same result, please suggest me where im doing wrong

vMonth: =if(len(GetCurrentSelections()),max(MonthYear),MonthStart(Today()))

=if(Date($(vMonth),'MMM YY'), if ((RAG_RATING_CD) = 'R', 'Tier1',

if ((RAG_RATING_CD) = 'A', 'Tier2',

if ((RAG_RATING_CD) = 'G', 'Tier3'))),

if(Date($(vMonth)-10,'MMM YY'), if ((RAG_RATING_CD) = 'R', 'Tier1',

if ((RAG_RATING_CD) = 'A', 'Tier2',

if ((RAG_RATING_CD) = 'G', 'Tier3'))),

if(Date($(vMonth)-50,'MMM YY'), if ((RAG_RATING_CD) = 'R', 'Tier1',

if ((RAG_RATING_CD) = 'A', 'Tier2',

if ((RAG_RATING_CD) = 'G', 'Tier3'))))))

Best Regards,

Niranjan

Re: month variable not working For all months i got the same results

sunny_talwar — Fri, 18 Mar 2016 13:10:54 GMT

I see a if statement, but no comparison?

What is $(vMonth) getting compared to? Today() or something else?

Re: month variable not working For all months i got the same results

Ralf-Narfeldt — Fri, 18 Mar 2016 13:57:53 GMT

Yes, the expression that is being evaluated is Date($(vMonth),'MMM YY'), and if that always returns a non-zero value, that will mean TRUE everytime.

Re: month variable not working For all months i got the same results

NavinReddy — Fri, 18 Mar 2016 14:50:53 GMT

Hi Sunny,

thanks for your reply

if can i select Month=Jan16

i will compare &(vMonth) automatically Dec15, Nov15

but im getting three months(Jan16,Dec15,Nov15) same values

any suggestions

Best Regards,

Niranjan

Re: month variable not working For all months i got the same results

NavinReddy — Fri, 18 Mar 2016 16:48:06 GMT

Hi Ralf ,

Any suggestion on above error

Regards,

Niranjan

Re: month variable not working For all months i got the same results

NavinReddy — Fri, 18 Mar 2016 17:03:05 GMT

Hi Sunny,

Here is the comparison im calculating

=if(Date($(vMonth),'MMM YY'),

=if(Date($(vMonth)-10,'MMM YY'),

=if(Date($(vMonth)-50,'MMM YY'),

Best Regards,

Niranjan

Re: month variable not working For all months i got the same results

NavinReddy — Mon, 21 Mar 2016 12:24:25 GMT

Dear Experts Good Morning,

Any suggestions

i have tried with different ways but im not getting

based on MonthYear selections for three months im calculating the Tiers

But all months im getting the same result

Thanks in Advance

Niranjan

Re: month variable not working For all months i got the same results

Ralf-Narfeldt — Mon, 21 Mar 2016 12:28:24 GMT

Can't see how your solution works, but you need to replace Date($(vMonth) with a condition that doesn't evalute as TRUE every time, which I think it does today.

Re: month variable not working For all months i got the same results

NavinReddy — Mon, 21 Mar 2016 12:33:28 GMT

Hi Ralf,

i have attached sample document for your reference

can you please check if im doing wrong in some where

Thanks,

Niranjan

Re: month variable not working For all months i got the same results

Digvijay_Singh — Mon, 21 Mar 2016 12:48:11 GMT

Check the output of pieces of expression like Date($(vMonth)-10,'MMM YY') in text box and check if it is showing results as expected.

Also you may provide more facts about the problem like what results it shows when you select something and when you don't select something.

Re: month variable not working For all months i got the same results

t_chetirbok — Mon, 21 Mar 2016 13:30:20 GMT

Hi!

please find attachment!

Re: month variable not working For all months i got the same results

NavinReddy — Mon, 21 Mar 2016 13:33:12 GMT

Hi Digvijay,

i checked with 3 texboxes with the =Date($(vMonth),'MMM YY'),=Date($(vMonth)-10,'MMM YY'),Date($(vMonth)-50,'MMM YY') i got the three different months

when im using same in expression its not working for all the months im getting same result

please refer sample application attached

Best Regards,

Niranjan

Re: month variable not working For all months i got the same results

t_chetirbok — Mon, 21 Mar 2016 13:36:57 GMT

I think it is what you need

Re: month variable not working For all months i got the same results

NavinReddy — Mon, 21 Mar 2016 13:41:18 GMT

Hi Tatsiana,

please find the below image Sep'15 i have 7 Tier1's but i got the only one

Can you please check the expression based on month selection its not give exact values

Best Regards,

Niranjan

Re: month variable not working For all months i got the same results

NavinReddy — Mon, 21 Mar 2016 13:42:08 GMT

Hi Tatsiana,

Exactly

Re: month variable not working For all months i got the same results

Digvijay_Singh — Mon, 21 Mar 2016 13:43:57 GMT

May be because your expressions are missing left side of condition expression like =

if(Your date Date = (Date($(vMonth),'MMM YY'),

Re: month variable not working For all months i got the same results

Digvijay_Singh — Mon, 21 Mar 2016 13:45:03 GMT

I don't have licensed version so cannot check the app.

Re: month variable not working For all months i got the same results

t_chetirbok — Mon, 21 Mar 2016 13:45:28 GMT

check app once again!

Re: month variable not working For all months i got the same results

NavinReddy — Mon, 21 Mar 2016 13:48:37 GMT

Wow your rock Tatsiana,

exactly same i am looking for, Can you please tell me how you did this

Thanks a lot

Regards,

Niranjan