Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jmonroe918
Creator II
Creator II

Calculated Expression - Line Chart

Attached is a table of data that I want to use for creating a line chart. I want to use "Yr/Mon" as the dimension. I want to calculate the overall combined (for all sites) complaints per million: (sum of complaints/sum of shipments)*1,000,000 for each Yr/Mon. I would also like when I select a site, it calculates the CPM for each Yr/Mon for that site alone.

What is the expression calcuation? I know it's not a matter of adding up the CPMs.

Thanks.

Jeff

1 Solution

Accepted Solutions
Gysbert_Wassenaar

The expression is simply sum(Complaints)/sum(Shipments)*1000000. Use Yr/Month as dimension for the line chart. Add a listbox for Site to select the sites. See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

The expression is simply sum(Complaints)/sum(Shipments)*1000000. Use Yr/Month as dimension for the line chart. Add a listbox for Site to select the sites. See attached qvw.


talk is cheap, supply exceeds demand
jmonroe918
Creator II
Creator II
Author

Gysbert:

Did you attache at file?

Jeff

sundarakumar
Specialist II
Specialist II

Hi Jeffrey,

The file has been attached by Gysbert,

Guess u r seeing the reply through mail,

Please login to see the attachment.

-Sundar

jmonroe918
Creator II
Creator II
Author

Sundar:

I haven't seen any attachment in this post. Where would it be?

Jeff

jmonroe918
Creator II
Creator II
Author

Sundar:

Never mind. I found it.

Thanks.

Jeff

sundarakumar
Specialist II
Specialist II