topic Re: How to do computation in getting previous and current data in qliksense? in App Development

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

kristeljoymalapitan — Sat, 16 Nov 2024 19:38:13 GMT

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

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

Arthur_Fong — Wed, 20 Nov 2019 02:44:22 GMT

You have a sample app?

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

kristeljoymalapitan — Thu, 09 Jan 2020 09:34:59 GMT

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

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

Arthur_Fong — Fri, 10 Jan 2020 03:02:52 GMT

What is the expected output for Nov and Dec?

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

kristeljoymalapitan — Fri, 10 Jan 2020 05:55:10 GMT

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%

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

Arthur_Fong — Fri, 10 Jan 2020 06:21:47 GMT

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

I don't see any issue here.

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

kristeljoymalapitan — Fri, 10 Jan 2020 06:33:06 GMT

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

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

Arthur_Fong — Fri, 10 Jan 2020 06:41:14 GMT

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.

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

kristeljoymalapitan — Tue, 21 Jan 2020 01:45:53 GMT

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)