topic set analysis in QlikView

set analysis

Anonymous — Mon, 04 Mar 2013 09:09:52 GMT

Dear all,

is there anyone who can put me on the right track ?

I don't know how to solve the folowinf problem:

I would count all the supplier with purchase value = 0

=count({<VALUE = {"=sum({<VALUE = {0}>} VALUE)> 0"}>} distinct SUPPLIER)

In the excel file all the supplier data

Help please , I'm making crazy

Mon, 04 Mar 2013 09:23:42 GMT

Hi,

Try with this expression..

Count({$<VALUE = {0} >} Distinct SUPPLIER)

Note: For optimization point of distinct count not recommended.

Karthik

perumal_41 — Mon, 04 Mar 2013 10:16:30 GMT

use this expression

count({<SUPPLIER= {"=sum({<VALUE = {0}>} VALUE)> 0"}>} distinct SUPPLIER)