Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satish25
New Contributor III

Ignore a particular selection and showing the result as zero

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)


1 Solution

Accepted Solutions
Highlighted
devarasu07
Honored Contributor II

Re: Ignore a particular selection and showing the result as zero

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))

3.JPG


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

2.JPG

4 Replies
Partner
Partner

Re: Ignore a particular selection and showing the result as zero

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?

Highlighted
devarasu07
Honored Contributor II

Re: Ignore a particular selection and showing the result as zero

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))

3.JPG


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

2.JPG

luismadriz
Valued Contributor

Re: Ignore a particular selection and showing the result as zero

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
New Contributor III

Re: Ignore a particular selection and showing the result as zero

Thanks Devarasu. This equation works

Cheers