This content has been marked as final. Show 2 replies
I created a qlikview with a pivot table.
dimension 1 dimension 2 sales(with set analysis selections) bonus 7.5% of sales
Sales = a calculated expression where i with set analysis only the sales take of the last 6 month.
In the bonus expression i try this
if(demension 2 <> 'value',[sales] * 0.075,0)
This works great. However it calculates on totals with the by the if statement excluded ( <> 'value') included.
Something like this
dimension 1 aa € 100.00 7.5
dimension 2 bb € 200.00 0 excluded with if statement
Total € 300.00 22.50 (instead of 7.5)
I tried to put a sum around [sales]*0.075 but get an error on it.
Please help me to get the correct total.