topic Multiplying 2 Expressions in QlikView

Multiplying 2 Expressions

Fri, 28 Jul 2017 16:11:03 GMT

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

Re: Multiplying 2 Expressions

sunny_talwar — Fri, 28 Jul 2017 16:13:21 GMT

Assuming you have this

1) Sum(Measure1) -> Label1

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

You can do this

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

Re: Multiplying 2 Expressions

Fri, 28 Jul 2017 20:11:54 GMT

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?

Re: Multiplying 2 Expressions

sunny_talwar — Fri, 28 Jul 2017 22:17:13 GMT

Try this

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

Re: Multiplying 2 Expressions

sasiparupudi1 — Fri, 04 Aug 2017 11:45:16 GMT

Like the attached?

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

Re: Multiplying 2 Expressions

Tue, 22 Aug 2017 17:31:25 GMT

that worked! thanks so much!