Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ramu_i
Contributor III
Contributor III

Exclude the selected value and display the Total

Hi all,

I have a county information 

Here 

Country    State   Values 

IND      AP   10

IND     TS    20

IND    KA    30

IND    DL    50      in this way

Requirement:

Filters, Country and State.

Country is IND  KPI display the 110 

If select the state is   AP----110-10=100

If select the state is AP,KA ----110-10-30=70 ...

Total - selected values 

Only selected values for one KPI --- Ap is state  display -10

KA , AP ----30+10 

Here some time country info is there ,Some times country info not there in this case find the country for the state.

 

Thanks 

Ram

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

As below

 

=sum({<State=>}TOTAL <Country> Values)-sum(Values)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

As below

 

=sum({<State=>}TOTAL <Country> Values)-sum(Values)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Ramu_i
Contributor III
Contributor III
Author

Hi Vinieme,

Thanks for your are valuable solution.

It's working fine.

Regards,

Ram