Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field called years. The field years contains the years from 2009 to 2013. I am using bar graph chart. My requirement is that the year 2011 should not displayedin the bar graph. It should be done only in the front end.
Can any one help me in resolving the above scenario.
Thanks
Sriram
HI
Try like this
= Sum({<Year -={2011}>}Sales)
Hope it helps
Calculated dimension:
IF(years=2011, NULL(), years)
Then tick "Do not show nulls"
Cheers
HI,
In the dimensions, instead of using the field 'years' edit it to use 'if(years<>'2011',years)
or even better, in your expressions use condition: sum(if(years<>'2011',"the field to calculate"))
Hi ssriramin19,
adds a dimension calculated
if(YEAR= 2011,Null(),YEAR)
other option is
=Aggr(MaxString({$<YEAR-= {2011}>}YEAR),YEAR)
Hi Sriram ,
In the Dimension try to have below code .
If ( Year <> 2011 , Year )
Also tick the CheckBox of Suppress when Value is Null .
Please let me know if there is anything .
Hi SriRam,
You can exclude Year 2011 in set analysis expression by using -= like below
=Sum({<Year-={2011}>} Sales)
Qlikview will show error new -=, but it works.
Hope this helps you.
Regards,
Jagan.
Thanks it works .Now I have achieved the requirement.
Thanks everyone for your time
Thanks it works .Now I have achieved the requirement.
Thanks everyone for your time