Ignore a particular selection and showing the result as zero

[satish25]

Hello All,

I am using a Bar Graph In Qlik Sense

Suppose I have the following :

    Dimension : Customer_ Name

    Measure : Sum({<Country=>}Sales)

The Measure equation Shows the 'Sum of Sales'  Excluding any selections made in the Country Dimension.

But I want such a Result that whenever I select any value in the Country Dimension the Graph should show me only "Zero" values (i.e. the graph should appear blank).

This should happen only for the Excluded Dimension and not any other Dimension (i.e. changes should appear to all the selections made in other dimensions)

[OmarBenSalem]

Sorry, but even though you've obviously tried ur best to elaborate ur need; I still have some doubts..

Can u please share a screenshot of what u have (as a current behaviour) and what u want to change?

[devarasu07 · Accepted solution]

Hi,

u can try like below,

Step 1: add cal. condition on data handling  in your pie chart

if(GetSelectedCount(Country)>0, 0,sum( {<Country=>}Sales))

2) then if u select any country then i will give u blank screen

[luismadriz]

Hi Satish,

Can you please explain again your requirement.

Do you want to exclude the selected countries?

Do you want to exclude all countries is any is selected?

Do you want to select only countries with Zero in sum of sales?

What you don't want is people selecting countries?

Cheers,

Luis

[satish25]

Thanks Devarasu. This equation works

Cheers