Different Layouts depending on Year

[raajaswin]

Hi All,

Consider the data

Year	Dim	Data
2000	A	45
2000	A	4
2000	B	456
2001	A	54
2001	C	54
2001	B	22
2001	A	10
2002	B	10
2002	B	90
2002	A	66

My output should be,

Year	Dim	sum
2000	A	49
2000	B	456

Year	Dim	sum
2001	A	64
2001	B	22
2001	C	54

Year	Dim	sum
2002	A	66
2002	B	100

I need separate chart for each year. for suppose data for year 2003 gets added to the layout a new chart for 2003 should get generated. In OBIEE we have something called section,if we give Year dimension in section, based on that layouts will be generated . any IDEA in Qlikview?

[stabben23]

Hi use set analysys in Your Expression

sum{<Year={'2000'}>}Data), this will gives you only 2000 year values.

do the same in all Charts.

[raajaswin]

My problem is not in filtering years!.   I can manually create three layouts for three years. But when data gets added for next upcoming  year, I need seperate chart for it

[stabben23]

Ok, Create variables which holds Your year, like

LET vYear = year(today()); //This year

LET vPreviousYear = year(today())-1; //Previous Year

Then inside Expression use variable sum{<Year={$(vYear)}>}Data),

or use it without variables like:

sum({<Year={$(=max(Year))} Data) so when a New year is added it will use max year.

if i'm totally lost here, explain it more detailed.

[raajaswin]

No, i think you are not getting me.

However we create variable , or use max of year. we need to manually create the number of charts we want .

If I have 2001,2002,2003,2004 I need 4 charts. If data gets added for 2005, i need a new chart to be generated as a 5th one.

[raajaswin]

Is it possible in qlikview?

[stabben23]

Hi, ok, you can not "autocreate" them, but you can prepare them and use show conditional so it will show up when year will be 2005. it Will be hided as long as you dont have 2005 (2017 in my case)

[raajaswin]

well, Just posted this to know is there any way to automate based on dimension!.

Refer Section in OBIEE. Thats what exactly I want.

Thank u.