topic Re: Hide Expression Columns Apart From Total in QlikView

Hide Expression Columns Apart From Total

Tue, 01 Jul 2014 13:09:59 GMT

Hi all,

As per the attached screenshot, I'd like to only show the TOTAL column for one of my expressions.

In the attached screenshot, I'd like to see All the 'S' values, and then only the very last 'P' value which is the total.
I don't want to change the font color as this will still leave the column and will also hide the TOTAL 'p' column.

Any ideas?

Thanks

Re: Hide Expression Columns Apart From Total

Gysbert_Wassenaar — Tue, 01 Jul 2014 13:22:37 GMT

That's not possible. You can try adding a calculated dimension to a column with the p totals on the left side with the other dimension columns. If you have a dimension column DimA and an expression sum(Value) the you could use =aggr(sum(Value),DimA) as calculated dimension.

Re: Hide Expression Columns Apart From Total

Tue, 01 Jul 2014 13:46:25 GMT

Great thanks very much. That has done the trick! Much appreciated.