topic Removing value from Pivot Table in QlikView

Removing value from Pivot Table

Anonymous — Mon, 02 Apr 2012 08:21:10 GMT

Hi,

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

vijay_iitkgp — Mon, 02 Apr 2012 08:23:58 GMT

Hi,

You can check the supress Null value in dimension tab

v_iyyappan — Mon, 02 Apr 2012 09:32:06 GMT

Hi,

Check the Suppress when value is null in dimension tab.

I attached a sample image.

Hope its helps.

Iyyappan

SunilChauhan — Mon, 02 Apr 2012 09:50:50 GMT

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

Mon, 02 Apr 2012 10:06:48 GMT

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