Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis and field calculation

Hi,

How can I calculate and compare a field in set analysis;

I'm trying to guess, count of estimated Customer Sales for given variables but I can't do that.

=Count( Sales * 1.1 = {">1000"}

2 Replies
Gysbert_Wassenaar

Try count({<Sales={'>$(=1000/1.1)'}>} Sales)


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

I have static ranges like 0-35.000.  In 2012 there are  230 customers which their sales at that range. In additon I have a parameter and estimating market growth like "10%". At the end I have to say that next year we are estimating 200 customers will be at that range.

Range | Count of Customers 2012 | Estimated Count of Customers 2013

0-35.000 | 230 | 200

35.000 - 70.000 | 120 | 140

70.000+ | 110 | 120