Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression based on condition

dim1productpriceamounttotal
xxxA224
xxxB616
xxxC339

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)

4 Replies
Chanty4u
MVP
MVP

may be this

hide.PNG

sunny_talwar

Like I mentioned here (condition based expression), would you be able to share a sample?

buzzy996
Master II
Master II

do u like this?

match.PNG

swuehl
MVP
MVP

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