Discussion board where members can get started with QlikView.
i need to calculate only discount value from total sales value.
i am not getting how to write expression.
Go to Solution.
I think this is fine
=Sum(Sales * Discount)
plz provide some sample data
Formula May be like this:
So Suppose Your Sales =100,
Discount Percentage= 10%
I need to calculate discount value(for eg. second row sales value is 3709.395 and discount 10% so want to find discount value)
i have different discount like
Please try with this
I think your willl the issue is with the discount field, if it shows as 10% it will be dealing with it as a string.
Either in Script add
NUM(PURGECHAR(Discount,'%')) AS DiscountNum
Or in the set analysis