Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Conditional Expression

I have following pivot table in My Doc

Screenshot_1.png

I want to show under the Financial Institute Column only Institutes which exceeds only 10% of total Value-2016

eg:  Arpico Finance= Net Total/Total

                                  75836/77277= 98% to be shown

       Natition Insuranec Brokers= 2200/77277= 2.8% not to be shown

My Calculated dimension for Financial Institute is

Screenshot_2.png

Can you suggest me solution for this  and It should be for pivot table please.

1 Solution

Accepted Solutions
sunny_talwar

5 Replies
prma7799
Master III
Master III

Please share some sample app.

sunny_talwar

This?

Capture.PNG

upaliwije
Creator II
Creator II
Author

Thanks Sunny

It is really amazing your solutions. However When I apply this to my original document I get an additional row just below the total row. What could be the reason ? Further I can not understand this 1e10 . Pls  help

Screenshot_2.png

sunny_talwar

Just check 'Suppress When Value Is Null' for your first dimension on the dimensions tab of chart properties

upaliwije
Creator II
Creator II
Author

Thanks a lot Sunny