topic Re: Using Pre-calculated value in QlikView

Using Pre-calculated value

mmainiero — Wed, 01 Feb 2017 15:59:40 GMT

Hi all,

I would like to reuse a calculated value from a diagram in another diagram. Or a new formula that produces just this result.

I have attached an Example Script to show my Problem.

Unfortunately i cant do this in my Datamodel <-- so I would like to do it this way.

Thanks

Markus

sunny_talwar — Wed, 01 Feb 2017 16:04:37 GMT

In a text box object? May be this

=Sum(Aggr(If(sum(Expression3/Expression1) >= 6, 1, 0), Dim1))

xyz1 — Sun, 14 Apr 2019 12:49:45 GMT

sunny_talwar — Thu, 02 Feb 2017 12:44:46 GMT

Where? You have not shared any link my friend?

mmainiero — Fri, 03 Feb 2017 12:15:26 GMT

Hi,

now I have the Problem, that I wan´t to use a set expression in my Formula.

=Sum(Aggr(If(sum( <SetExpression> Expression3/Expression1) >= 6, 1, 0), Dim1))

for example DIM2 should be "c" is this possible?

It results in Nested expressions are not allowed...

Kind Regards,

Markus

sunny_talwar — Fri, 03 Feb 2017 12:17:36 GMT

Like this?

=Sum({<DIM2 = {'c'}>}Aggr(If(sum({<DIM2 = {'c'}>}Expression3/Expression1) >= 6, 1, 0), Dim1))

mmainiero — Fri, 03 Feb 2017 13:14:31 GMT

Thank you! Solved my Problem!

Regards,

Markus