Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There - am struggling with some Qlik Sense expressions that work just fine in Qlikview - I'm trying to recreate the app in Qlik Sense
=Sum((BUDGET_VOLUME)*(1+(vOrderQtyChangePctg/100))) - brings back 0.00 as a the result.
Budget_Volume is column in a table, where as vOrderQtyChangePctg is a variable show value I set with a slider.
If I split the above as =Sum(BUDGET_VOLUME)+Sum(BUDGET_VOLUME*(vOrderQtyChangePctg/100)) then I get a result.
The issue is I have more additions and multiplications to do ...
Here's the equation that works just fine in Qlikview
floor(Sum
(
((BUDGET_VOLUME*(1+vOrderQtyChangePctg/100))*(BUDGETNETPRICE+vAdjPriceChange)) -
((BUDGET_VOLUME*(1+vOrderQtyChangePctg/100))*
(UNIT_FIXED_COST*(1+vFixCostChange/100)+
UNIT_VAR_COST*(1+vVarCostChange/100)
)
)
)
)
Hopefully, its something simple that I'm doing wrong.
thanks for any help, suggestions.
Regards
RK
closing thread as i found out the issue. The variable's default value was not set correctly. thanks Karthik.
Hi Raj,
can you try with Dollar Expansion for the variable?
=Sum((BUDGET_VOLUME)*(1+($(vOrderQtyChangePctg)/100)))
-Karthik
thanks for the note Karthik. Unfortunately that didn't work.
Here's what I tried
=Sum(BUDGET_VOLUME*(1+$(vOrderQtyChangePctg)/100))
OR
=Sum(BUDGET_VOLUME*(1+($(vOrderQtyChangePctg)/100)))
neither worked - the result is blank, not 0.00
regards
Hi Raj,
Can you check the individual values like
sum(BUDGET_VOLUME) or $(vOrderQtyChangePtcg) and check whether values are correct?
-Karthik
Also, what is the variable definition?
here it is... not sure if this is the issue. The idea was 0.00 will be the default value
Thanks for any suggestions/help
closing thread as i found out the issue. The variable's default value was not set correctly. thanks Karthik.