Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to create a sensitivity analysis visualization? For example, to analyze how the sales margin varies under different discounts.
One way to achieve this is to use variable for the discount in the expression. The same variable can be used in the variable input object available in the Qlik dashboard bundle. We can apply various discount values through the variable input and analyse how sales margin varies due to the change.
Thank you so much! I have tried but something is wrong. I have this expression:
=sum([Sales])-(vDiscount/100*sum([Sales]))
is working, but I just want to apply the discount when the products are from a specific family:
=(sum([Sales])-(<{Family={'Profiles'}>}(vDiscount/100)*sum([Sales])))
but this isn't working
auto solved 🙂
=sum([Sales])-(vDiscount/100*sum({$<Family={'Profiles'}>}([Sales])))