Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Re: Year display

HI

Try like this

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

Hope it helps

Not applicable

Re: Year display

Calculated dimension:

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

Then tick "Do not show nulls"

Cheers

sbobbyraj
Contributor III

Re: Year display

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

dagomezl
Contributor III

Re: Year display

Hi ssriramin19,

adds a dimension calculated

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

other option is

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

Not applicable

Re: Year display

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 .

MVP
MVP

Re: Year display

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.

Highlighted
ssriramin19
New Contributor II

Re: Year display

Thanks it works .Now I have achieved the requirement.

Thanks everyone for your time

ssriramin19
New Contributor II

Re: Year display

Thanks it works .Now I have achieved the requirement.

Thanks everyone for your time