Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

bibopipo
Not applicable

set analysis

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

2 Replies
Not applicable

Re: set analysis

Hi,

Try with this expression..

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

Note: For optimization point of distinct count not recommended.

Karthik

perumal_41
Not applicable

Re: set analysis

use this expression

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