topic display particular year with current selection year in QlikView

display particular year with current selection year

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

If I want to display 2019 year sales with current selection year sales in a barchart what's the expression.

Dimension is year.

Year data is like this 2016, 2017, 2018, 2019. So if I select 2018 , I want to display 2018 data as well as 2019 data in common and not display other years data.

Re: display particular year with current selection year

Lisa_P — Wed, 04 Sep 2019 05:49:56 GMT

Using Set Analysis, you can do this.

Lets assume your measure is Sum(Sales), then to include 2019 and what ever year is selected:

Sum({$<Year+={2019}>}Sales)

Re: display particular year with current selection year

Karthiek22 — Wed, 04 Sep 2019 06:04:58 GMT

Thank you,

But if I select any year , I want to display that year (2016,2017,2018)and one common particular year(2019).

If I select 2016 , I want to display only 2016 and 2019 data.

If I select 2017 , I want to display only 2017 and 2019 data.

Re: display particular year with current selection year

Lisa_P — Wed, 04 Sep 2019 06:06:16 GMT

Have you tried this ?

Re: display particular year with current selection year

Karthiek22 — Wed, 04 Sep 2019 06:07:44 GMT

Ya...it shows only selected year data.

Re: display particular year with current selection year

Lisa_P — Wed, 04 Sep 2019 06:12:46 GMT

This works for me