Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

MayitaMayoso
New 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
Highlighted
miskinmaz
Contributor II

Re: Show only incrementing graphs

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])