topic Re: Set Analysis in QlikView

Set Analysis

Wed, 22 Oct 2014 09:47:11 GMT

Hi,

What is the best Set Analysis script to do a Count of Sum(Value)=0?

Rgards,

FLC

ashfaq_haseeb — Wed, 22 Oct 2014 09:51:54 GMT

Try below

=Count({<Value={'0'}>}ID)

Regards

ASHFAQ

Wed, 22 Oct 2014 09:55:57 GMT

Try this

Count({<Value={'0'}>} Fieldname)

Gysbert_Wassenaar — Wed, 22 Oct 2014 10:02:08 GMT

Perhaps this: count({<ID={'=sum(Value)=0'}>} distinct ID)

Wed, 22 Oct 2014 10:20:02 GMT

Hi,

Thanks, I already tryed that but is not working for what I need.

Let me explain better:

Fields

StoreID ProductID Qt_Sold RowCounter [=1]

How Can I count the number of products per Stores with Sum(RowCounter)=0?

Regards,

FLC

ashfaq_haseeb — Wed, 22 Oct 2014 10:25:44 GMT

Hi,

Can you come up with sample data and expected o/p.

will RowCounter store 0 for not sold or what is the logic behind it?

Regards

ASHFAQ

its_anandrjs — Wed, 22 Oct 2014 10:53:27 GMT

What expression you use please provide that one.

Regards

Anand