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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiplying 2 Expressions

Hi all!

I have 2 calculated expressions.  One column is a simple sum of a dollar amount.  The other column is a percentage calculation, with the relative box checked to make the percentages relative to the whole.  I want to multiply these two columns together, but it will not work since one column is relative and the other is not.  Can I multiply 2 expressions using the 'Label' I created for each expression?  Is there a function I can use to make one part of the equation relative and the other not relative?

Does anyone have any idea how to fix this?

Thank you

1 Solution

Accepted Solutions
sunny_talwar

Try this

[Label Name1] * ((Count(Measure2)/Sum(Measure3))/(Count(TOTAL Measure2)/Sum(TOTAL Measure3)))

View solution in original post

5 Replies
sunny_talwar

Assuming you have this

1) Sum(Measure1) -> Label1

2) Sum(Measure2) -> Label2 -> Relative...

You can do this

3) Label1 * (Sum(Measure2)/Sum(TOTAL Measure2))

Not applicable
Author

Thank you for your response.  1) is correct. but 2) isn't just a sum.  it is: count(Measure2)/Sum(Measure3).  Also, can Label1 have spaces in it?  Does that matter?

sunny_talwar

Try this

[Label Name1] * ((Count(Measure2)/Sum(Measure3))/(Count(TOTAL Measure2)/Sum(TOTAL Measure3)))

sasiparupudi1
Master III
Master III

Like the attached?

It should be possible of what you want to achieve..may be providing a sample app would be great.

Not applicable
Author

that worked! thanks so much!