Solved: products that haven't been sold in the period - Qlik Community - 1698041

Skip to main content

Qlik.com | Qlik Help | Resources

Ask a Question

ho all.

in my model i have a table that presents sum of sales by product according to the year selected.

i want to present the product that were not sold in that period .

any ideas ?

advanced thanks

Labels (6)

Labels

2 Solutions

Accepted Solutions

I think you should take a look at E() element function.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnaly...

Good Luck.

View solution in original post

Author

Solved with calculated dimension

If (aggr(sum(sales),product_name)=0,product_name)

View solution in original post

3 Replies

I think you should take a look at E() element function.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnaly...

Good Luck.

Here is a Design Blog post to Set Analysis as well just in case you may need some further help there:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

Author

Solved with calculated dimension

If (aggr(sum(sales),product_name)=0,product_name)