Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

List products not used

Hi,

I have a report listing all orders of a pirticular product, supplier, location and period.

the script has a Orders table and seperate tables for list of products, suppliers, location.

i would like to make a chart/table of all products which have not been orderd (having no records in orders table) for a given period and given suppliers.

Any suggestions on how can we do that ?

Thank you.

kind regards,

Devang.

1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

List products not used

put product in dimension

the write this expression

if(count(OrderdId)=0,1,0)

2 Replies
lironbaram
Honored Contributor II

List products not used

put product in dimension

the write this expression

if(count(OrderdId)=0,1,0)

Not applicable

List products not used

Thanks Iiron, that helped. Exactly what i was looking for. :-)

Community Browser