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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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?