Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
gidon500
Creator II
Creator II

Charts

Hi

enclosed is a sample sales chart

i want to add an indicator of customer sales VS total sales

can you help ?

gidon

Labels (1)
1 Solution

Accepted Solutions
morganaaron
Specialist
Specialist

Hi Gidon,

Change the 'ration' expression to read: Sum(Sales) / Sum (Total Sales)

View solution in original post

3 Replies
morganaaron
Specialist
Specialist

Hi Gidon,

Change the 'ration' expression to read: Sum(Sales) / Sum (Total Sales)

rubenmarin
MVP
MVP

Hi gidon, ratio expression can be:

=SUM(sales)/SUM(TOTAL sales)

ssriramin19
Contributor III
Contributor III

Please refer the attachement . It is now as per your requirement