Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
mellerbeck
Creator II
Creator 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
sunny_talwar

Try this

Sum({<Benchmark>} Revenue)


Capture.PNG

mellerbeck
Creator II
Creator II
Author

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

sunny_talwar

Then try this

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

mellerbeck
Creator II
Creator II
Author

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