topic Re: Problem with total between 2 expressions in QlikView

Problem with total between 2 expressions

Thu, 24 Jan 2013 18:24:39 GMT

I have 2 totals of 2 different expressions of a chart table (Simple Table), I need to make the total 1 divided by the total 2, but

I can not bring the correct value since the total 1 is a sum (which has Set Analysis) and total 2, the number of rows (expression NoOfRows(TOTAL)) in the table, does anyone know how to solve this issue?

Thank you.

Re: Problem with total between 2 expressions

Thu, 24 Jan 2013 19:05:39 GMT

try using AGGR()

Re: Problem with total between 2 expressions

IAMDV — Thu, 24 Jan 2013 20:24:37 GMT

Hi Gabriel,

It's difficult to guess your expression and data to provide you with the exact expression. However, you can use the Label Names of both the expression and refer them in the third expression as part of your calculations.

For Example:

Expression1 is TotalSales. Which is Sum(Sales) as my expression.

Expression2 is TotalItems. Which is Sum(Qty) as my expression.

Now you can write third expression referring the labels i.e. TotalSales/ TotalItems. This will work as long as you are referring the Label Names within the same object type.

If this doesn't work then please post the sample app and we can mock up something for you.

Cheers,

www.QlikShare.com