topic Re: Expression Independent from dimension in QlikView

Expression Independent from dimension

Thu, 08 Oct 2015 14:53:40 GMT

Hi,

I have 10 stores that sell 20 different products.

How can I create a straight table that, for every products, tell me how many stores didn't sell that product?

Anonymous — Thu, 08 Oct 2015 15:05:50 GMT

Hi Patrizio,

Dimension: Product

Expression: Count({<Sales = {'0'}>}Stores)

Thu, 08 Oct 2015 15:14:50 GMT

Your data is aggregated or each transaction level ?

You can Try like below:

Count({<Stores={"=Sum(SalesAmount)=0"}>}Stores)

rubenmarin — Thu, 08 Oct 2015 15:29:07 GMT

Hi Patrizio, maybe:

Count(TOTAL DISTINCT Store) - Count(DISTINCT Store)

swuehl — Thu, 08 Oct 2015 16:12:20 GMT

Dimension: Product

Expression: = Sum( Aggr( If(Sum(SalesAmount)=0,1,0), Product, Store))

Anonymous — Wed, 09 Dec 2015 14:58:37 GMT

The problem is with the incoming data. You can't display what doesn't exist.

Add a sale of 0.0001 to each product that the store didn't sell.

When you sum sales the missing store data for a product will be $0.00

A bar chart will also show what looks like zero sales for stores that didn't sell product.