Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mmainiero
Contributor II
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

1 Solution

Accepted Solutions
sunny_talwar

In a text box object? May be this

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

View solution in original post

6 Replies
sunny_talwar

In a text box object? May be this

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

xyz1
Creator III
Creator III

.

sunny_talwar

Where? You have not shared any link my friend?

mmainiero
Contributor II
Contributor II
Author

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

Like this?

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

mmainiero
Contributor II
Contributor II
Author

Thank you! Solved my Problem!

Regards,

Markus