topic Re: Count if and distinct in QlikView

Count if and distinct

Anonymous — Mon, 29 May 2017 15:46:56 GMT

Dear All,

I am pretty new using set analysis and I am having some trouble while calculating an Indicator through a database on qlikview.

The base has the structure below. What I want to do is to count the number of distinct IDs which has number 1 in the column on the right ("Raw Material"). This column may be 1 or 0 in one same ID.

For instance, the calculation using the base below has to be 2.

Can someone help me?

ID	Raw Material
1	1
1	0
1	1
2	1
2	1
2	1
3	0
3	0

Re: Count if and distinct

Peter_Cammaert — Mon, 29 May 2017 16:05:21 GMT

Something like this?

=count({<[Raw Material] = {1}>} DISTINCT ID)

Re: Count if and distinct

tajmohamed30 — Mon, 29 May 2017 17:33:00 GMT

Hi Daniel,

Following steps may help;

Step1: Create listbox with field Raw material

Step2: Create listbox with field ID(in properties general tick show frequency)

Step3: Create straight table with dimension ID and expression as sum(Raw material)

Now you can select 0 or 1 in Raw material to show distinct ID values

Regards

Taj Mohamed