Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Solved with calculated dimension
If (aggr(sum(sales),product_name)=0,product_name)
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
Solved with calculated dimension
If (aggr(sum(sales),product_name)=0,product_name)