Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kristeljoymalapitan

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

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

sample.png

Labels (3)
9 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

You have a sample app?

kristeljoymalapitan
Author

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
Partner - Specialist III
Partner - Specialist III

What is the expected output for Nov and Dec?

kristeljoymalapitan
Author

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

MONTHENDCURRENT OBPREVIOUS OBGrowth Rate
NOV-201973,19210,000(considering that there is October 2019 monthend)6.31%
DEC-201919,78773,192-0.73%
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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
Author

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

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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)MC.PNG

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
Author

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
Partner - Specialist III
Partner - Specialist III

Please do share a sample app.