Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Winstodge
Contributor II
Contributor II

KPI Measure to show total

Hi

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

Thank you

Winnie

4 Replies
abhijitnalekar
Specialist
Specialist

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.

 

 

Regards,
Abhijit
keep Qliking...
Winstodge
Contributor II
Contributor II
Author

Hi Abhijitnalekar

Please see below

Winstodge_0-1634223105544.png

 

abhijitnalekar
Specialist
Specialist

Hi @Winstodge ,

 

Go to the Appearance--> Styling 

and disable the below Auto button 

abhijitnalekar_0-1634223540578.png

Once you disable the Auto you will get the options 

abhijitnalekar_1-1634223616249.png

 

Hope this helps you.

 

Regards,
Abhijit
keep Qliking...
Winstodge
Contributor II
Contributor II
Author

Apologies for not marking this as closed

I sorted this by using

=sum(NET_PRICE / PRICE_UNIT*RECE_QTY)

Regards