topic Create report of non selected items in QlikView

Create report of non selected items

picturebox — Fri, 25 Nov 2011 15:53:51 GMT

Hello,

I show in a report (pivot or straight table) across which stores a product has sold in which calendar week. I would like to turn that around and show where the product has NOT sold. The way I currently do it is to select the product and the time, then the list box of stores shows me the greyed out stores, so those that have not sold during that week ... how can I elegantly turn that into a report? Still using 9 SR7 ...

Thanks!

Petra

Create report of non selected items

swuehl — Fri, 25 Nov 2011 18:56:30 GMT

Hi Petra,

you could try creating a straight table chart with dimension stores, and as expression

=only({<stores=e(stores), product=, time= >}stores)

You could hide the expression afterwards in presentation tab, if you want, so you only get one column with store names. You need to replace stores, product and time with your fields.

Hope this helps,

Stefan

Create report of non selected items

picturebox — Fri, 25 Nov 2011 20:59:30 GMT

I am away from my system now til Monday, but one question: doesn't this method require that a store has at one point sold that product? I am not familiar with the excluded in a set analysis expression, I'll have to look that up.

Thanks, let you know if it works.

Petra

Re: Create report of non selected items

swuehl — Sat, 26 Nov 2011 14:08:07 GMT

No, I don't think that this is required. Please check attached sample.

Stefan