Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

mmainiero
New Contributor II

Using Pre-calculated value

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

Tags (1)
1 Solution

Accepted Solutions

Re: Using Pre-calculated value

In a text box object? May be this

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

7 Replies

Re: Using Pre-calculated value

In a text box object? May be this

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

agrimroquette
Contributor II

Re: Using Pre-calculated value

hello sunny T please help me i have started an discussion. i am stuck please

agrimroquette
Contributor II

Re: Using Pre-calculated value

friend please help..

Re: Using Pre-calculated value

Where? You have not shared any link my friend?

mmainiero
New Contributor II

Re: Using Pre-calculated value

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

Re: Using Pre-calculated value

Like this?

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

mmainiero
New Contributor II

Re: Using Pre-calculated value

Thank you! Solved my Problem!

Regards,

Markus

Community Browser