Year display

[ssriramin19]

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

[MayilVahanan]

HI

Try like this

= Sum({<Year -={2011}>}Sales)

Hope it helps

[#3]

Calculated dimension:

IF(years=2011, NULL(), years)

Then tick "Do not show nulls"

Cheers

[Anonymous]

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"))

[Anonymous]

Hi ssriramin19,

adds a dimension calculated

if(YEAR= 2011,Null(),YEAR)

other option is

=Aggr(MaxString({$<YEAR-= {2011}>}YEAR),YEAR)

[#6]

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 .

[jagan]

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.

[ssriramin19]

Thanks it works .Now I have achieved the requirement.

Thanks everyone for your time

[ssriramin19]

Thanks it works .Now I have achieved the requirement.

Thanks everyone for your time