Qlik Community

Ask a Question

New to QlikView

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

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

Creator II
Creator II

Gysbert:

Did you attache at file?

Jeff

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

Creator II
Creator II

Sundar:

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

Jeff

Creator II
Creator II

Sundar:

Never mind. I found it.

Thanks.

Jeff

Specialist II
Specialist II