topic Re: Different Layouts depending on Year in QlikView

Different Layouts depending on Year

raajaswin — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Different Layouts depending on Year

stabben23 — Wed, 18 Jan 2017 10:20:39 GMT

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.

Re: Different Layouts depending on Year

raajaswin — Wed, 18 Jan 2017 10:36:36 GMT

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

Re: Different Layouts depending on Year

stabben23 — Wed, 18 Jan 2017 11:00:11 GMT

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.

Re: Different Layouts depending on Year

raajaswin — Wed, 18 Jan 2017 11:47:18 GMT

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.

Re: Different Layouts depending on Year

raajaswin — Wed, 18 Jan 2017 11:47:42 GMT

Is it possible in qlikview?

Re: Different Layouts depending on Year

stabben23 — Wed, 18 Jan 2017 11:55:41 GMT

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)

Re: Different Layouts depending on Year

raajaswin — Wed, 18 Jan 2017 12:56:56 GMT

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.