topic Re: Set Analysis for Modifiers not present in QlikView

Set Analysis for Modifiers not present

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

Hi Geeks,

I am using Set analysis to show Product wise sales for every ID.

Eg:- Sum({<Product={'A'}>}Sales)

Please find attached QVW and data file.

Question:

I want to display Sum as Null if no Products are available for a particular id like in below example:

For ID 1 products available are A and B so I don't Want to Show "0" but Null().

Sum(Sales) for a particular product can be Zero or Null()

Appreciate your help.

Thanks and Regards,

Pankaj

sunny_talwar — Wed, 11 Oct 2017 16:33:31 GMT

May be use a pivot table or use an expression like this

If(Sum({<Product={'A'}>}Sales), Sum({<Product={'A'}>}Sales))

passionate — Wed, 11 Oct 2017 16:53:02 GMT

Thanks Sunny.

What if i also want to show Sum(Sales) as Zero as Well?

antoniotiman — Wed, 11 Oct 2017 16:53:34 GMT

You wrote

Sum(Sales) for a particular product can be Zero or Null()

May be this

If(Count({<Product={'A'}>} Product)> 0,Sum({<Product={'A'}>} Sales))

sunny_talwar — Wed, 11 Oct 2017 16:55:00 GMT

What do you mean that you want to show it as 0 and null both at the same time?

passionate — Wed, 11 Oct 2017 17:06:54 GMT

Thanks, You both are Gem

Cheers!!!!