topic Re: Expression only show null values in Pivot Table in QlikView

Expression only show null values in Pivot Table

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

I need an expression that only shows BIN where the QUANTITY = 0? I don't need any other fields to be displayed.

What kind of expression do I need?

Re: Expression only show null values in Pivot Table

Anil_Babu_Samineni — Mon, 08 May 2017 09:23:34 GMT

You mean to say this?

Only({<QUANTITY = {0}>}BIN)

Re: Expression only show null values in Pivot Table

sunny_talwar — Mon, 08 May 2017 09:28:50 GMT

May be like this

Dimension

Bin

Expression

If(Sum(Quantity) = 0, 1, 0)

Re: Expression only show null values in Pivot Table

khaycock — Mon, 08 May 2017 09:29:37 GMT

When I use this as an expression, it returns the same amount for the BIN and the expression. I tried it as an dimension and it didnt work

Re: Expression only show null values in Pivot Table

khaycock — Mon, 08 May 2017 09:32:57 GMT

This is just displaying 1 for everything? I only need to show BINS where the QUANTITY = 0?

Re: Expression only show null values in Pivot Table

sunny_talwar — Mon, 08 May 2017 09:35:13 GMT

Really? Even if use this if statement which says that only show 1 when Sum(Quantity) = 0, assign a 1, else a 0? Can you share an image after adding another expression

Dimension

Bin

Expression

If(Sum(Quantity) = 0, 1, 0)

Sum(Quantity)

Re: Expression only show null values in Pivot Table

Anil_Babu_Samineni — Mon, 08 May 2017 09:35:49 GMT

Can you show the image, And explain the result

Re: Expression only show null values in Pivot Table

khaycock — Mon, 08 May 2017 09:53:00 GMT

Oops sorry that was my fault. You're right, thanks!