topic If condition in QlikView

If condition

NavinReddy — Thu, 15 May 2014 20:44:46 GMT

Dear all,

I have fine business groups

[New Wkly ]='GWM ,'GIM ,Architecture','Tech,Risk,'Application Services') ;

these filters i have But i want to use only two filters in Pivot Table

if(Wildmatch([New Wkly],'GWM ','GIM '),[New Wkly ])

I am Using This filter in Pivot table but im getting all Business Data

Could some one help to me solve this issue

Thanks In Advance

Niranjan

Re: If condition

Anonymous — Thu, 15 May 2014 20:52:31 GMT

can you try if ([New Wkly]='GWM ' or [New Wkly]='GIM ',[New Wkly])..if this does not work please post your qvw file it would be easy to solve

Re: If condition

NavinReddy — Thu, 15 May 2014 21:08:44 GMT

please find the attechment

and second chart im trying to filetering

Best Regards,

Niru

Re: If condition

maxgro — Thu, 15 May 2014 21:22:29 GMT

maybe

check Suppress When Value Is Null

in Dimension Tab for the calculated dimension

=if(Wildmatch([New Wkly HC Rpt Level 1],'GWM Operation','GIM Operation'),[New Wkly HC Rpt Level 1])