Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
MayitaMayoso
Contributor
Contributor

Show only incrementing graphs

Hi all!

I have a graph where I show the sales by year and by product and I want to show only those products which never had a down in its sales in the specified data range.

I have no idea where to start. What do you reccomend me?

1 Reply
miskinmaz
Creator III
Creator III

Hi,
You can use the advance set analysis
For example you can refer to the below expression. The scenario was to find a customer who has not done any sales in past year (new customer)

count({<[Customer Code]-=
{'=count( aggr(count({<[Fiscal Year]={"<$(=max([Fiscal Year]))"}>} distinct [Customer Code]),[Customer Code]))<>0'}>}distinct [Customer Code])