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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

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