Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

ssriramin19
New Contributor II

Year display

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

17 Replies
mov
Esteemed Contributor III

Re: Year display

Sriram,

You can use set analysis to eliminate a specific value.  If Year is a dimension of the chart, it will be a calculated dimension:
aggr(only({<Year-={2011}>} Year), Year)
Don't forget to check "suppress when value is null".

Regards,
Michael

ssriramin19
New Contributor II

Re: Year display

Can anyone help in resolving the above scenario. It is very urgent

Thanks for your time..

sivarajs
Valued Contributor II

Re: Year display

Try by generating calenadr adte using

Date(Ceil(Rand() * 1460) + Date('01/01/2009')) AS CalendarDate //1460 days from 01/01/2009 almost four years

Use year of calendar date as your dimension

MVP
MVP

Re: Year display

You can use a calculated dimension:

=if( years <> 2011, years)

Not applicable

Re: Year display

use the calculated dimension if ( Year='2011',Null(),Year) and check the Suppress when Value is null option.

Highlighted

Re: Year display

if you use years as dimension you can write

if(years <> 2011, years, null())

and check the box hide null values

narender123
Valued Contributor

Re: Year display

you can use query in script

eg.

load

a,b,c,Year

from ......

where Year>=2009 and <=2010 or Year>=2012 and <=2013;

I think this will help you.Try it.

Thanks.

Employee
Employee

Re: Year display

use "=if(years<>'2011',years,null())" as your dimension and enable Suppress when value is null for that dimension.

Not applicable

Re: Year display

Hi,

Write an if with 'different from 2011'.

By Rebeca

Community Browser