Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i am showing an example data
table1:
load * inline [product
a
b
c
d
e
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.
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 !
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)
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