How to do computation in getting previous and current data in qliksense?

[kristeljoymalapitan]

Hi,

Can anyone help me to solve this,

I need to compute growth rate using previous and current OB, however figures for previous data in qlik sense changed.

Please see below provided sample output from qliksense and sample expected output made in excel

formula : (Current OB - Previous OB)/Previous OB

[Arthur_Fong]

You have a sample app?

[kristeljoymalapitan]

Hi @Art,Hi @Arthur_Fong 

Please see sample app, please check measures used (Growth Rate measure)

Kindly advice what will be the best approach in doing growth rate.   

Thank you

[Arthur_Fong]

What is the expected output for Nov and Dec?

[kristeljoymalapitan]

Hi @Arthur_Fong ,

If you will see GROWTH RATE on my provided SAMPLE_DATA app, expected output will be like this,

formula:

(CURRENT OB-PREVIOUS OB)/PREVIOUS OB

MONTHEND	CURRENT OB	PREVIOUS OB	Growth Rate
NOV-2019	73,192	10,000(considering that there is October 2019 monthend)	6.31%
DEC-2019	19,787	73,192	-0.73%

[Arthur_Fong]

You might need to confirm with your DB Admin on how to achieve current and previous OB.

I don't see any issue here.

[kristeljoymalapitan]

@Arthur_Fong  you mean used measure is correct to get the growth rate on mentioned sheet/report?

[Arthur_Fong]

Yes.  Nov OB is 73,192. Dec Previous OB should be grabbing the same figure, but it is not. Even after removing set analysis, the result is still the same. (Current and Previous column)

If there is an ETL layer lies before the dashboard, do check on the logic created for <PREV_OB_NET_OF_AP_EXCESS> field. 

[kristeljoymalapitan]

Hi @Arthur_Fong  please see sample scenarios on data 

table1

accountno

OB as previous_OB

left join table2

accountno

OB as current_OB

above sample query contains same columns with previous and current data (monthend)

Can I share sample app for checking

Thank you

[Arthur_Fong]

Please do share a sample app.