Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Removing value from Pivot Table

Hi,

Capture.PNG

I am filtering my pivot table, with

                                                        = if(Dimension1 like 'ABC*',Dimension1)


I get the correct Values when ever Dimension1  starts with 'ABC' , but all the other dimension total is showing at the bottom and I do not wants this,

any idea on how I remove this.

Kind Regards

Razak

1 Solution

Accepted Solutions
v_iyyappan
Specialist
Specialist

Hi,

     Check the Suppress when value is null in dimension tab.

I attached a sample image.

Hope its helps.

Iyyappan

View solution in original post

4 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi,

You can  check the supress Null value in dimension tab

v_iyyappan
Specialist
Specialist

Hi,

     Check the Suppress when value is null in dimension tab.

I attached a sample image.

Hope its helps.

Iyyappan

SunilChauhan
Champion
Champion

convert chart to straight tablee

then go to exression-> select no total

for each expression

convert now to pivot table

in presentation ->uncheck partial sum

hope this helps

Sunil Chauhan
Not applicable
Author

Hi dreamer,

just see the attachement, now it show sum if id stating with ABC and not sum of all dimension

I hope this is what you looking for

Thanks & Good Luck

Anant Dubey