This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
You have a sample app?
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.
What is the expected output for Nov and Dec?
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
You might need to confirm with your DB Admin on how to achieve current and previous OB.
I don't see any issue here.
@Arthur_Fong you mean used measure is correct to get the growth rate on mentioned sheet/report?
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
Please do share a sample app.