topic Re: YOY comparison, ignore selection for one year in QlikView

YOY comparison, ignore selection for one year

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

Not quite sure how to define this, but given

LOAD * INLINE [

Shipment Year, Benchmark, Revenue, Region

2018, A, 100, 1

2018, A, 200, 2

2018, C, 300, 1

2017, B, 50, 1

2017, B, 100, 2

];

So they want a chart that displays sum of Revenue for 2017 versus 2018. The problem is the benchmark for 2017 doesn't match 2018.

So if benchmark A is selected then the 2017 data isn't selectable. I can use

SUM({1<[Shipment Year]=>} Revenue) for full set, but then selections that are made in region aren't reflected.

So, Shipment year of 2018 is selected and Benchmark A is selected. I would like 2017 to ignore the Benchmark selection but still be able to make selections in Region to display for 2017 and 2018.

Thanks for any thoughts!

Message was edited by: Michael Ellerbeck added ship year selection

Re: YOY comparison, ignore selection for one year

sunny_talwar — Wed, 13 Jun 2018 16:49:32 GMT

Try this

Sum({<Benchmark>} Revenue)

Re: YOY comparison, ignore selection for one year

mellerbeck — Wed, 13 Jun 2018 17:07:39 GMT

Ahh, close but there is a selection in shipment year of 2018

Re: YOY comparison, ignore selection for one year

sunny_talwar — Wed, 13 Jun 2018 17:46:47 GMT

Then try this

Sum({<Benchmark, [Shipment Year]>} Revenue)

Re: YOY comparison, ignore selection for one year

mellerbeck — Wed, 13 Jun 2018 18:13:12 GMT

The benchmark selection needs to apply to 2018, but not 2017