topic Re: Nested If statement not working in QlikView

Nested If statement not working

Wed, 25 Nov 2020 16:16:04 GMT

I need to display a stacked bar chart with 2015, 2016 , 2016-Q3, 2016-Q4 and 2016 - Jul as X axis, whereas Jul is in the third quarter as per the calendar.

=if(FY_12='2015',FY_12,(if (FY_12='2016' and Quarter_12='3',FY_12&'-Q'&Quarter_12,(if (FY_12='2016' and Quarter_12='4',FY_12&'-Q'&Quarter_12,(if(FY_12='2016' and Month_12='Jul',

FY_12 & '-'& Month_12,(if (FY_12='2016',FY_12,)) ))

))) ))

As per the above if condition, the charts are not displaying values for 2016-Jul. Could someone help me in tweaking this if condition?

Re: Nested If statement not working

Anil_Babu_Samineni — Thu, 20 Oct 2016 16:25:53 GMT

Does Jul You have taken Manually.

=if(FY_12='2015',FY_12,if(FY_12='2016' and Quarter_12='3',FY_12&'-Q'&Quarter_12,if (FY_12='2016' and Quarter_12='4',FY_12&'-Q'&Quarter_12,if(FY_12='2016' and Month_12='Jul', FY_12 & '-'& Month_12,if (FY_12='2016',FY_12)))))

Re: Nested If statement not working

Thu, 20 Oct 2016 16:35:04 GMT

Yes, I have passed as Jul manually , at this point.

Re: Nested If statement not working

Anil_Babu_Samineni — Thu, 20 Oct 2016 16:41:29 GMT

Some Performance, It might helps

=if(WildMatch(FY_12='2015',FY_12), if(Pick(FY_12='2016' and Quarter_12='3',Match(FY_12, Quarter_12)),

if (Pick(FY_12='2016' and Quarter_12='4',Match(FY_12,Quarter_12)), if(Pick(FY_12='2016' and Month_12='Jul', Match(FY_12, Month_12), if (WildMatch(FY_12='2016',FY_12))))))

Re: Nested If statement not working

Thu, 20 Oct 2016 17:24:04 GMT

Hmm, thanks for the suggestions , but not working Anil.

Re: Nested If statement not working

Anil_Babu_Samineni — Fri, 21 Oct 2016 01:58:35 GMT

Why it not working? Is there any screen shot. can you provide i/p Why it's not working

Re: Nested If statement not working

avinashelite — Fri, 21 Oct 2016 04:29:06 GMT

could you be able to share the sample app ??

Re: Nested If statement not working

sushil353 — Fri, 21 Oct 2016 05:07:55 GMT

Try this out

=if(FY_12='2015',FY_12,

if (FY_12='2016' and Quarter_12='3',FY_12&'-Q'&Quarter_12,

if (FY_12='2016' and Quarter_12='4',FY_12&'-Q'&Quarter_12,

if(FY_12='2016' and Month_12='Jul',FY_12 & '-'& Month_12,

if (FY_12='2016',FY_12)

)

Re: Nested If statement not working

shraddha_g — Fri, 21 Oct 2016 06:28:44 GMT

Try

if( wildmatch(FY_12,'2015') , FY_12,

if(wildmatch(FY_12,'2016') and wildmatch( Quarter_12,'3'), FY_12&'-Q'&Quarter_12,

if(wildmatch(FY_12,'2016') and wildmatch( Quarter_12,'4'),FY_12&'-Q'&Quarter_12,

if(wildmatch(FY_12,'2016') and wildmatch( Month_12,'Jul') ,FY_12 & '-'& Month_12,

if( wildmatch(FY_12,'2015') , FY_12 )))))

I hope it is helpful.

Re: Nested If statement not working

Fri, 21 Oct 2016 06:55:14 GMT

Hey Guys,

Thanks so much for all your solutions. It seemed like since there is only one month (Jul) in the respective quarter (in this scenario Q4) and when I provide conditions for both Q4 and Jul month it is producing data in a single bar instead of multiple. Now that I have added one more month in the data (Ex : Aug) to the Q4, all the above mentioned conditions produce two bars , one for Q4 and another for Jul, which is eventually right.s

Regards,

Arun

Re: Nested If statement not working

tamilarasu — Fri, 21 Oct 2016 06:58:07 GMT

Hi Arunkumar,

Try this,

=if(FY_12='2015',FY_12,

if(FY_12='2016' and Match(Quarter_12,'3','4'),FY_12&'-Q'&Quarter_12,

if(FY_12='2016' and Month_12='Jul',FY_12 & '-'& Month_12,

if(FY_12='2016',FY_12

)

If it's not working, I would suggest to post a sample application.

Re: Nested If statement not working

shraddha_g — Fri, 21 Oct 2016 07:03:35 GMT

Also you can try

if( wildmatch(FY_12,'2015','2016') , FY_12,

if(wildmatch(FY_12,'2016') and wildmatch( Quarter_12,'3','4'), FY_12&'-Q'&Quarter_12,

if(wildmatch(FY_12,'2016') and wildmatch( Month_12,'Jul') ,FY_12 & '-'& Month_12

)))

Re: Nested If statement not working

sasiparupudi1 — Fri, 21 Oct 2016 07:23:57 GMT

If you are using this as a calculated dimension, you need to add the same logic in your expressions otherwise it is not going to show the results.

Please post a sample