topic Variable for Table fields in a table chart in QlikView

Variable for Table fields in a table chart

alec1982 — Fri, 11 Jan 2013 22:03:45 GMT

Hi Guys,

I have a table chart that shows as follow:

Location 2013 2014 2015 Sales

....... .... ... .. ...

....... ... .. .. ...

Is there anyway I can make the fields variables like

Dimenssion one= Location

Dimenssion two = Year(Today())

Dimenssion three=Year(Today())+1

Dimenssion Four =Year(Today())+2

Expression = Sum(Sales)

so next year i dont need to change anything on the chart and will delete 2013 by itself and add the new years

I tried to put it in the dimenssion as it Year(Today()) but it gave me error

Thxs,

Alec

Re: Variable for Table fields in a table chart

nagaiank — Fri, 11 Jan 2013 23:51:06 GMT

Try to save the data in a table with three fields (Location, Year and Sales)

In the bar chart use the calculated dimension

=If([Year] >= Year(Today()) or [Year] <= Year(Today())+2,[Year],Null())

Also check 'Suppress When Value is Null' for the dimension

Hope this helps.

Re: Variable for Table fields in a table chart

alec1982 — Sat, 12 Jan 2013 17:43:34 GMT

This is perfect, however I added couple of years just as a sample, what if we have more then 3 years in total, how can I get the dimenssion to show up to max year?

Thxs for all your help!

Alec

Re: Variable for Table fields in a table chart

nagaiank — Sat, 12 Jan 2013 18:02:16 GMT

You may control the years to display using the calculated dimension. As an example, if you want to display three year of data ending with the max(year), your calculated dimension expression will be

=If(Year >= $(=Max(Year))-2, Year, Null())