topic Re: Have a chart containing unselected values ? in QlikView

Have a chart containing unselected values ?

fredericvillemi — Tue, 19 Sep 2017 13:35:51 GMT

Hello,

I have a crosstab list with several Dimensions : Region / Country / City and a few KPIs : amount of Sales / nb Customers

The chart shows all the data and when I select a specific Region, it filters on this region. Great !

Now I would like to have a second chart which contains the opposite of that :

Nothing when everything is available in the first chart
all the non selected region or other dimensions when a region is selected and shown in the first chart

I tried something like {1-$} but it's not good, but I'm probably not too far.

And, bonus question, how could I merge that in a single chart ?

For exemple having one more first dimension called "Scope" with everything selected in "Current Scope" and all other data in "Others" scope

Thanks

krishnacbe — Tue, 19 Sep 2017 13:50:57 GMT

Try below Expression

Sum({<Region=E()>}Sales)

fredericvillemi — Wed, 20 Sep 2017 08:41:19 GMT

Hello,

that's really nice, not the same thing as {1-$}

And can I cumulate dimensions ? Region=E(),Country=E() ? is there a priority ?

Thanks

krishnacbe — Wed, 20 Sep 2017 14:01:34 GMT

I hope no Priority is needed.

krishnacbe — Wed, 20 Sep 2017 14:02:18 GMT

I will set the excluded values based on the order you mentioned.