Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Set Analysis

Hi,

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

Rgards,

FLC

Tags (1)
1 Solution

Accepted Solutions

Re: Set Analysis

Try below

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

Regards

ASHFAQ

6 Replies

Re: Set Analysis

Try below

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

Regards

ASHFAQ

Not applicable

Re: Set Analysis

Try this

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

Re: Set Analysis

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


talk is cheap, supply exceeds demand
Not applicable

Re: Set Analysis

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

Re: Set Analysis

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

Re: Set Analysis

What expression you use please provide that one.

Regards

Anand

Community Browser