This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a table that I have with a sum total at the top, I am trying to create a KPI measure to show the Total. Below is in the table.
=Num(RECE_QTY,'#,##0')*SUM(NET_PRICE / PRICE_UNIT)
i have tried using the rangesum but get "0"
=rangesum(Num(RECE_QTY,'#,##0',NoOfRows(total)))*RangeSum(NET_PRICE / PRICE_UNIT, NoOfRows(total))
I have also tried
=Rangesum(Above(Column(8), 1, NoOfRows(TOTAL)))+RangeSum(Below(Column(8), 0, NoOfRows(TOTAL)))
But I still get a "0"
Any suggestion's would be welcome
Hi @Winstodge ,
Can you please share an image of your table structure.
The reason being asking this as in Qliksene table we can move total from top to bottom also.
Please see below
Go to the Appearance--> Styling
and disable the below Auto button
Once you disable the Auto you will get the options
Hope this helps you.
Apologies for not marking this as closed
I sorted this by using
=sum(NET_PRICE / PRICE_UNIT*RECE_QTY)