Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Saurabh07
Contributor III
Contributor III

To eliminate entries where sum of values is 0

Hello Gurus,

I have the mentioned data set,

CountryValue
Algeria10
Andorra1
Angola0
Anguilla0
Algeria2
Andorra9
Angola0
Anguilla0
Algeria7
Andorra3
Angola2
Anguilla0
Algeria3
Andorra6
Angola5
Anguilla0

 

Now I am trying to eliminate the country 'Andorra' and all other countries whose sum of Values is 0. I have successfully eliminated 'Andorra' from my pivot table with mentioned expression:

sum({<Country -= {'Andorra'}>}Value), but struggling to achieve the second condition. So my desired output in pivot form has to be;

CountrySum of Value
Algeria22
Angola7

 

Can anyone please help me out here?

14 Replies
Saurabh07
Contributor III
Contributor III
Author

@Lisa_P  Thank you for the suggestion. But I am afraid this might not be the solution I am looking for, as I am already limiting the data for some other measure. I mean in the same pivot, I am already limiting the countries greater than 80% of another measure. 

Taoufiq_Zarra

@Saurabh07its a sample table

or you can always do :

in Country dimension use :

if(aggr(sum(Value),Country)>0,Country) and uncheck include null value

and in measure sum({<Country -= {'Andorra'}>}Value)

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Kushal_Chawda

@Saurabh07  uncheck below option

Screenshot 2020-10-23 111529.png

Saurabh07
Contributor III
Contributor III
Author

@kaushiknsolanki Great, it worked! Thank you!

Saurabh07
Contributor III
Contributor III
Author

@Kushal_Chawda  @Taoufiq_Zarra @kaushiknsolanki  @Lisa_P  Thank you guys, each of your solutions work in specific case. Thank you so much!!