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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
CerebosSA
Contributor
Contributor

Count Growth by Store

Good Morning, I want to count how many stores reflect a positive or a negative volume  growth. 

My expression is as follows: 

=Count({< vVolumeGrowth = {'<0'} >}distinct [Store Description])

It shows the total number of stores 2.88k not the amount with negative growth.

Thought?

Thanks

 

 

4 Replies
tresesco
MVP
MVP

How is your variable vVolumeGrowth defined? Or, this is an input value from user?

CerebosSA
Contributor
Contributor
Author

Hi, it as below

(sum ({$<Year= {$(vMaxYear)}>} (Units))

/

sum ({$<Year={$(=Max(Year)-1)},Cal_YearMonth = {"<= $(=Max(Cal_YearMonth)-101)"}>} (Units)))-1

tresesco
MVP
MVP

In set modifier, a field name is expected before the '=' sign. In your case, you are passing a possible numeric value which is not accepted. 

CerebosSA
Contributor
Contributor
Author

Can you provide an example?