topic Re: count elements by pareto class in QlikView

count elements by pareto class

Thu, 03 Jul 2014 10:45:58 GMT

hi,

i have created a pivot table that represents pareto class. i would count elements belonging in a-class and elements belonging in b-class. After that put the number in a text box. Have you got any idea ? which formula do i use ? thanks

Re: count elements by pareto class

tresB — Thu, 03 Jul 2014 10:49:09 GMT

May be like:

=Count( {<[Pareto Class]={'A'}>}YourField)

=Count( {<[Pareto Class]={'B'}>}YourField)

'Distinct' keyword is upto your requirement.

Re: count elements by pareto class

Thu, 03 Jul 2014 13:17:13 GMT

THANKS for the reply. as you can see from the attached image i am trying to insert the formula you suggested me, but, in the blue textbox on the left it returns zero as result. It seems it does not recognize the field. Is it correct the sintax ? How do i change the formula ?

The analysis of pareto is on the right into straight table.

thank you very much

Re: count elements by pareto class

tresB — Fri, 04 Jul 2014 06:34:31 GMT

You are right Daniele,

DANIELE ZECCHETTO wrote:

..... It seems it does not recognize the field. ....

and you would be the right person to tell the right field name.

Re: count elements by pareto class

nenadvukovic — Sat, 02 Aug 2014 15:09:01 GMT

Hi, I have a similar problem of not being able to get the count of items by dynamically created classes (Is it possible at all to get a summary table?)

Were you able to get it? Thx

Re: count elements by pareto class

nenadvukovic — Wed, 06 Aug 2014 09:58:39 GMT

If you do not have the [Pareto Class] available in your data model, and I believe you do not as you want to have this to be dynamic, you can't use expressions outside the table.

Here is how I sorted out a similar issue to enable users to get this totals by classes calculated automatically and dynamically.