Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dim1 | product | price | amount | total |
---|---|---|---|---|
xxx | A | 2 | 2 | 4 |
xxx | B | 6 | 1 | 6 |
xxx | C | 3 | 3 | 9 |
I want to hide price and amount from product B and only show totals for the products A en C, i cant figure this out in Qlikview.
any suggestions?
Im using a pivot table with three expressions:
Amount:
(sum(amount)/count(DISTINCT Month))
Price:
(sum(total))/
(sum(amount)/count(DISTINCT Month))
total:
sum(total)
may be this
Like I mentioned here (condition based expression), would you be able to share a sample?
do u like this?
And please don't create multiple threads for the same topic, it's really hard to follow a discussion.
Seems you got a similar answers in both threads anyway