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
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.
Hi @Arthur_Fong ,
If you will see GROWTH RATE on my provided SAMPLE_DATA app, expected output will be like this,
(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%|
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.
Hi @Arthur_Fong please see sample scenarios on data
OB as previous_OB
left join table2
OB as current_OB
above sample query contains same columns with previous and current data (monthend)
Can I share sample app for checking