topic Re: Year display in QlikView

Year display

ssriramin19 — Tue, 09 Apr 2013 11:42:27 GMT

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

Re: Year display

Anonymous — Tue, 09 Apr 2013 12:33:08 GMT

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

Re: Year display

ssriramin19 — Tue, 09 Apr 2013 12:41:26 GMT

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

Thanks for your time..

Re: Year display

sivarajs — Tue, 09 Apr 2013 12:50:52 GMT

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

Re: Year display

swuehl — Tue, 09 Apr 2013 12:58:30 GMT

You can use a calculated dimension:

=if( years <> 2011, years)

Re: Year display

Tue, 09 Apr 2013 13:18:52 GMT

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

Re: Year display

alexandros17 — Tue, 09 Apr 2013 13:22:17 GMT

if you use years as dimension you can write

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

and check the box hide null values

Re: Year display

narender123 — Tue, 09 Apr 2013 13:32:25 GMT

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.

Re: Year display

kji — Tue, 09 Apr 2013 13:33:00 GMT

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

Re: Year display

Tue, 09 Apr 2013 13:38:17 GMT

Hi,

Write an if with 'different from 2011'.

By Rebeca

Re: Year display

MayilVahanan — Tue, 09 Apr 2013 13:39:07 GMT

Try like this

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

Hope it helps

Re: Year display

Tue, 09 Apr 2013 13:47:19 GMT

Calculated dimension:

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

Then tick "Do not show nulls"

Cheers

Re: Year display

Anonymous — Tue, 09 Apr 2013 14:09:42 GMT

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

Re: Year display

Anonymous — Tue, 09 Apr 2013 14:34:19 GMT

Hi ssriramin19,

adds a dimension calculated

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

other option is

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

Re: Year display

Tue, 09 Apr 2013 16:13:44 GMT

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 .

Re: Year display

jagan — Tue, 09 Apr 2013 17:19:12 GMT

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.

Re: Year display

ssriramin19 — Wed, 10 Apr 2013 11:43:38 GMT

Thanks it works .Now I have achieved the requirement.

Thanks everyone for your time

Re: Year display

ssriramin19 — Wed, 10 Apr 2013 11:43:42 GMT

Thanks it works .Now I have achieved the requirement.

Thanks everyone for your time