Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
See attached
example:
=if(RowNo()=0,
num([Over pack per drop >5]*0.53,'£ ##,###')
,num([Over pack per drop >5]))
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
have you tried checking the Indentation Option on Style tab?? with a pivot table
Goes all funny and repeats everything, ideally I want to be able to get rid of the expression columns
can you post a sample app?
Preparing examples for Upload - Reduction and Data Scrambling
Here you go
Check the attached, look at the expressions
Its changed the format on the white column from number to currency though
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
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?