topic Re: condition based expression in QlikView

condition based expression

Wed, 25 Nov 2020 16:16:04 GMT

from this:

to this, zero values are also fine:

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)

Re: condition based expression

sunny_talwar — Wed, 30 Mar 2016 11:30:03 GMT

Do you have a sample you can share with us?

Re: condition based expression

swuehl — Wed, 30 Mar 2016 11:41:40 GMT

Maybe something like this to show only Amount and Price for D

(sum({<Product = {D}>} amount)/count(<Product = {D}>} DISTINCT Month))

If( Match(Product,'D'),(sum(amount)/count(DISTINCT Month)), '')

[both expressions for Amount calculation in a chart with dimension Product]

Re: condition based expression

buzzy996 — Wed, 30 Mar 2016 11:44:56 GMT

see my comments from this thread.

Expression based on condition

don't put condition on total else apply condition like above link suggested.

Re: condition based expression

Wed, 30 Mar 2016 12:58:58 GMT

this worked thank you, is there a way to turn zero values into white cells ?

Re: condition based expression

Wed, 30 Mar 2016 13:12:39 GMT

Hi Tim Janse, if you want see just the products 'A' and 'C' add a 'Calculated Dimension' in place of 'Product' like dimension.

Try this 'Calculated Dimension':

if( Product='A' or Product='C' , Product)

With this, you will see in your Pivot Table the row values for product 'A' and 'C'.

I hope that it help you,

Regards

Re: condition based expression

Wed, 30 Mar 2016 13:17:43 GMT

But if i do that i cant see the totals for product B

Re: condition based expression

swuehl — Wed, 30 Mar 2016 13:19:15 GMT

And to keep the threads in-sync:

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

Re: condition based expression

swuehl — Wed, 30 Mar 2016 14:59:44 GMT

Tim Janse wrote:

this worked thank you, is there a way to turn zero values into white cells ?

Like a mentioned above?

If( Match(Product,'D'),(sum(amount)/count(DISTINCT Month)), '')