topic Re: Set analysis and field calculation in QlikView

Set analysis and field calculation

Thu, 20 Dec 2012 13:38:24 GMT

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"}

Re: Set analysis and field calculation

Gysbert_Wassenaar — Thu, 20 Dec 2012 13:42:00 GMT

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

Re: Set analysis and field calculation

Fri, 21 Dec 2012 09:37:30 GMT

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