Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

dreamer78692
Contributor

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
Valued Contributor

Re: Removing value from Pivot Table

Hi,

     Check the Suppress when value is null in dimension tab.

I attached a sample image.

Hope its helps.

Iyyappan

4 Replies
vijay_iitkgp
Valued Contributor

Removing value from Pivot Table

Hi,

You can  check the supress Null value in dimension tab

v_iyyappan
Valued Contributor

Re: Removing value from Pivot Table

Hi,

     Check the Suppress when value is null in dimension tab.

I attached a sample image.

Hope its helps.

Iyyappan

chauhans85
Esteemed Contributor

Removing value from Pivot Table

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

Not applicable

Re: Removing value from Pivot Table

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

Community Browser