Expression Totals On Row

[khaycock]

Hey,

Is it possible to have the highlighted expressions amount positioned underneath the amount, so where it says total now?

I'm not sure if it is something you can actually do on QlikView?

I think it would look better than having the extra columns.

Thanks!

[sunny_talwar]

I don't think there is any direct way to do this. There might be some work around, but will have to be tested out

[vinieme12]

have you tried checking the Indentation Option on Style tab?? with a pivot table

[khaycock]

Goes all funny and repeats everything, ideally I want to be able to get rid of the expression columns

[vinieme12]

can you post a sample app?

Preparing examples for Upload - Reduction and Data Scrambling

[khaycock]

Here you go

[vinieme12]

Check the attached, look at the expressions

[khaycock]

Its changed the format on the white column from number to currency though

[vinieme12]

You can Fix the formatting with NUM() function directly in the expression and Change formatting setting in Number tab to Expression Default

Let me know if you need help

[khaycock]

But the count is the white part which needs to be a number and the grey part underneath is the cost which needs to be in £. When changing the expression it changes the whole column. Is there a way to make them different?