Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using calculated Value for further Calculation

Hey there,


i have the following calculated Data in qlik:


Value1 = Formula (Dimension a)

Value2 = Formula 2 (Dimension b)

Value3 = Formula 2 (Dimension b) * Formula (Dimension a)


Value 4 then should be = Value 3 * Formula 2 (Dimension c)


I did the following:


above(sum(x))

*

(sum(x)

/

above(sum(y))

The next value would be like

above(

above(sum(x))

*

(sum(x)

/

above(sum(y)))

*

(sum(x)

/

above(sum(y))

and the next

Above(above(....

Anyone knows how i can handle this in one expression dynamically?

1 Reply
sunny_talwar

Would it be possible to share an app instead of just showing the generic idea behind what you are trying to do?