Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Qlik Sense Calculate Measure from other Calculated Measures

Hi,

I would like to create a table from a current (dynamic) selection, basically to be able to double check the calculation before I plot it.

In this table I would like to add some new dynamic calculated columns. I can easily create a single calculated measure. However, If I include this new column in yet another calculated field I get an error in the formula (The funny thing is that if the formula is simple enough, I still get the correct calculated values in the table)

My questions are:

1) How can I get around this? How can I use one or more calculated measures in the dependent calculated measure. What is the right way of doing this in Qlik?

2) I would also like to be able to use the Before() keyword in the formula of the current calculated measure. i.e to be able to get the previous value.

Thanks for your help.

Jose

2 Replies
shraddha_g
Not applicable

Re: Qlik Sense Calculate Measure from other Calculated Measures

You can refer previously calculated measures by column() in dependant measure.

for Ex. Measure 1 :  Expr1

          Measure 2 : Expr2

     then measure 3 : Column(1)/column(2)

Else you can create variable for all Previously calculated measures and then use those variables in measure.

I hope this is helpful.

Not applicable

Re: Qlik Sense Calculate Measure from other Calculated Measures

Hi Shraddha,

Yes, that does it. Somehow I missed that the Column() function works by number and only on the measures.

I also got the Before/After functions working on this as needed.

Perfect. Thanks again.

Jose