topic Re: finding unsaled products in QlikView

finding unsaled products

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

Hi all,

i am showing an example data

table1:

load * inline [product

f];

table2:

load * inline [product,amount

a,100

b,200

c,300];

for this i want to get unsaled products, a, b,c has some amount value but d,e,f doesnt have an amount so i want to get those records to show in straight table

but that can need to solve in expression not in script can anyone help me.

Re: finding unsaled products

kristof_j — Tue, 06 Feb 2018 07:33:50 GMT

I made a straight table with a calculated dimension

=if(aggr(count(amount),product)=0, product)

so if there is no amount found for product, product is shown, else nothing.

In the same Dimensions tab I checked 'supress when value is null'.

In the Presentation tab is unchecked 'supress zero values'

And I have a straight table with only the products with no sales !

Re: finding unsaled products

techvarun — Tue, 06 Feb 2018 07:47:49 GMT

table1:
load *,product as productUnsold inline [product
a
b
c
d
e
f];


table2:
load *,product as productSold inline [product,amount
a,100
b,200
c,300];


Load productUnsold as Unsold  Resident table1 where not exists (productSold,product)

Re: finding unsaled products

arvind_patil — Tue, 06 Feb 2018 07:53:16 GMT

Hi Manoj,

Please add below in expression:

and your Dimension : Product.

IF(Sum(amount)<=0,'True')

From Add-ons property remove checkbox.

Thanks & Regards,

Arvind Patil