topic Show field when no data allocated in QlikView

Show field when no data allocated

Mon, 13 Feb 2012 10:04:09 GMT

Hello,

Im sure this has been asked before but I cant find anything in search.

I have had a request to :

Show field entries where there is no entry in the dimention.

Example:

Normal : Select Customer , show Products and product prices

Required : Select customer, show products where there are no prices allocated to that customer.

Im going in cirlces and im sure there must be a simple solution!

Thank you in advance.

Mon, 13 Feb 2012 10:17:11 GMT

Note: I cant really use select excluded as its select customer first, not select product then select excluded if that makes sense.

jagan — Mon, 13 Feb 2012 10:31:22 GMT

Hi,

Can you attach sample file.

Regards,

Jagan.

Mon, 13 Feb 2012 10:51:10 GMT

Hi,

You could use an IF clause in the dimensions of a pivot table and suppress null. Example:

if(IsNull(Price), Product)

Regards,

sebablum

Fri, 17 Feb 2012 11:22:54 GMT

Hello - This iis a better explination of what I require.

Data : Company A Product ZZ Price 10

Company A Product XX Price 10

Company B Product ZZ Price 10

Company B Product CC price 20

regular selections for company A would bring up Dimention (Products) and expression Price

Result : Selection Company A

Table: Product ZZ Price 10

Product XX Price 10

What I require to show with Company A still as selection is :

Desired Result :

Table : Product CC Price 20

-- As in All products that do not have a price allocated to company A

Basically in the data set there is no entry for product CC for company A but tis this which I wish to display ie a mirror image of possible.

Anyone ideas?