topic Re: To get data for two years by selecting year using line chart in QlikView

To get data for two years by selecting year using line chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two years of data(2016,2017) in my QVD. I need to show my data in line chart.If I select 2017 year my data is showing in line chart but if I select 2016 it is not showing.I used expression like sum(Field name) and I browsed but I can get like

sum({$<year={"$(=only(year))"}>}Field-name) //current year

sum({$<year={"$(=only(year)-1)"}>}Field-name)

but it doesn't work.Is there any other expression to get it.Please help me to get it as soon as possible.

Thanks in Advance!!!!

Regards,

Harini S

Re: To get data for two years by selecting year using line chart

sunny_talwar — Tue, 14 Mar 2017 15:01:50 GMT

which of the three expressions are you using in your chart?

Re: To get data for two years by selecting year using line chart

adamdavi3s — Tue, 14 Mar 2017 15:04:42 GMT

sum(Field name) will work if you have year as a dimension

sum({$<year={"$(=only(year))"}>}Field-name) will work for the year you have selected (and only when you have one selected)

sum({$<year={"$(=only(year)-1)"}>}Field-name)will work when you have 2017 selected, but not when you have 2016 selected as you don't have year 2015 available

What exactly do you want to show?

A line comparing both years? If so add year as a dimension and use the first formula

Re: To get data for two years by selecting year using line chart

Tue, 14 Mar 2017 15:16:33 GMT

Thanks for your response!!!!

currently i am using sum(Field-name) but I tried those three expression but it doesn't work.

Re: To get data for two years by selecting year using line chart

Tue, 14 Mar 2017 15:20:59 GMT

Thanks for your response and great Explanation.

I don't want to add any value of 2016 and 2017.I need to just show when I select 2016 that year data to display in line chart and by selecting 2017 that year data to display in line chart.

I have tried those three expression but it doesn't work.Do u have any idea....

Re: To get data for two years by selecting year using line chart

german24 — Tue, 14 Mar 2017 15:33:07 GMT

Hi,

try this...

It show 2017 for the selecction Year = 2017:

sum({$<year={"$(=Max(year))"}>}Field-name) //current year

It show 2016 for the selecction Year = 2017:

sum({$<year={"$(=(Max(year)-1))"}>}Field-name)

Best regards,

German.

Re: To get data for two years by selecting year using line chart

sunny_talwar — Tue, 14 Mar 2017 17:59:10 GMT

Is your calendar table (or year field) correctly connected to the fact table which holds Field-name? Can you share an image of your data model?

Re: To get data for two years by selecting year using line chart

adamdavi3s — Wed, 15 Mar 2017 07:26:28 GMT

I agree with Sunny, I don't think your data is correctly linked otherwise sum(Field name) would always show you the correct data based on your selections

Re: To get data for two years by selecting year using line chart

Wed, 15 Mar 2017 11:43:51 GMT

Yes guys,I have add restriction so only it didn't work.Now I fixed it .Thanks for your help and quick reply.sorry for inconvenience.