topic Re: Formula Indicator in QlikView

Formula Indicator

pgalvezt — Thu, 23 Jun 2016 18:29:15 GMT

Hello,

I have a formula in my control indicator. But just works fine when I selected one filter. I would like to show the real result without selections in my filter...

So my outputs are:

Both Select gives 23%.

I would like to obtain 23% without Selections and not 123,8% .

Thanks You!

Re: Formula Indicator

Thu, 23 Jun 2016 19:00:24 GMT

Pablo:

Hard to tell what you are really trying to accomplish (my Spanish is marginal at best). It appears to me that your formulas may not yield the results you are seeking. To really simplify, you have:

(-a -b) / (-b), or eliminating the - (negative signs), (a+b) / b

Where a and b are your two sums with set logic. A standard growth calculation would be:

(current-previous) / (previous), or (current/previous) - 1

- or in your case

(a-b) / b

Or in the case of gross margin:

(revenue-cost) / revenue, or (b-a) / b

Whichever the case, I think you want the difference between the two items in your numerator - not the sum of them.

Re: Formula Indicator

pgalvezt — Thu, 23 Jun 2016 19:33:38 GMT

Hi Greg,

Hard to tell what you are really trying to accomplish : I need to show 23%. If you do clic in both filters P and O you will see that the final result is 23%. I need the same result but without selections.

I almost sure that my formula need an aggregation, But I´ve tried but doesn´t work.

Re: Formula Indicator

MindaugasBacius — Thu, 23 Jun 2016 19:48:08 GMT

Maybe Set analysis is the problem solver?

Re: Formula Indicator

pgalvezt — Thu, 23 Jun 2016 20:03:04 GMT

Yes, I almost sure that my formula need an aggregation, But I´ve tried but doesn´t work.

Re: Formula Indicator

Thu, 23 Jun 2016 20:18:53 GMT

Pablo:

so you would use the set expression: {<TipoExpression={'Otros'}>} for the numbers that need 'Otros', and {<TipoExpression={'Pagos'}>} for numbers that need 'Pagos', when you build your formulas. As an example

sum({<TipoExpression={'Otros'}>} fieldname) - sum({<TipoExpression={'Pagos'}>} fieldname)

as for 23% - what it appears you'll need is the combination of the two values, or a set expression like {<TipoExpression={'Otros','Pagos'}>} or in the larger example:

sum({<TipoExpression={'Otros','Pagos'}>} fieldname)

Hope this helps...

Re: Formula Indicator

pgalvezt — Thu, 23 Jun 2016 20:32:34 GMT

Works now thanks!