Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
mellerbeck
Contributor II

YOY comparison, ignore selection for one year

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

4 Replies

Re: YOY comparison, ignore selection for one year

Try this

Sum({<Benchmark>} Revenue)


Capture.PNG

mellerbeck
Contributor II

Re: YOY comparison, ignore selection for one year

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

Re: YOY comparison, ignore selection for one year

Then try this

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

mellerbeck
Contributor II

Re: YOY comparison, ignore selection for one year

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