Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Multiplying 2 Expressions

Try this

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

5 Replies
MVP
MVP

Re: Multiplying 2 Expressions

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

Re: Multiplying 2 Expressions

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?

MVP
MVP

Re: Multiplying 2 Expressions

Try this

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

sasiparupudi1
Honored Contributor III

Re: Multiplying 2 Expressions

Like the attached?

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

Not applicable

Re: Multiplying 2 Expressions

that worked! thanks so much!

Community Browser