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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ngreddy1982
Contributor III
Contributor III
‎2021-11-25 09:28 AM

Set analysis help

Hi All, 

I am trying to calculate product cost which comes from the Revenue * Product Factor, it is not working as expected. Please see the attachment. Please tell me what am I doing wrong here ? is this even the correct approach. 

Factor.qvw
10 KB
1,291 Views
0 Likes
1 Solution

Accepted Solutions
Vegar
MVP
MVP
‎2021-11-25 09:51 AM

It looks like you have a one factor per row of revenue. I think it should be enough to just do 

Sum(Revenue*Product_Factor)

Vegar
Qlik Community MVP

View solution in original post

1,263 Views
0 Likes
3 Replies
Vegar
MVP
MVP
‎2021-11-25 09:51 AM

It looks like you have a one factor per row of revenue. I think it should be enough to just do 

Sum(Revenue*Product_Factor)

Vegar
Qlik Community MVP
1,264 Views
0 Likes
ngreddy1982
Contributor III
Contributor III
‎2021-11-25 10:03 AM
Author

Hi Vegar, 

I have 2 different events  Revenue and Cost, so Revenue is coming from Revenue Event and Product_Factor is coming from Cost and also I have to use Month Relative range in the expression. 

1,241 Views
0 Likes
ngreddy1982
Contributor III
Contributor III
‎2021-11-25 10:31 AM
Author

Thank you, I got this working, with AGGR I need to add all the dimensions I have in the chart. With Centre, I have added the Month name as well. it is working fine. 

Thank you Vegar.

1,213 Views