Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
Check the Suppress when value is null in dimension tab.
I attached a sample image.
Hope its helps.
You can check the supress Null value in dimension tab
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
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