topic Re: Problem with counting in QlikView

Problem with counting

Tue, 21 Apr 2015 07:21:57 GMT

Hello Everyone,

i want make this count in pivot table:

=count(DISTINCT( if(ENTRYDATE=ORDERDATE,

if( ID=FIRST_ID,

if(DOC_TYPE<>14, if(SOURCE_IDX<>7, ITEM))))))

My problem is that for ID=FIRST_ID i don't want make the control by row but by the column.

So for example if the table is that

ITEM

ORDERDATE

ENTRYDATE

FIRST_ID

DOC_TYPE

SOURCE_IDX

BOX1

20.03.2014

1111

BOX3

20.03.2014

1111

BOX1

20.03.2014

1111

BOX1

20.03.2014

1111

i want count 4 item for BOX1 because there are 4 FIRST_ID equal to ID of BOX1.

Can you Help me? PS: i don't know i fixed value for the ID because it changes for every ITEM

Thank you,

Alfonso

Re: Problem with counting

anbu1984 — Tue, 21 Apr 2015 08:06:04 GMT

=Aggr(count(DISTINCT( if(ENTRYDATE=ORDERDATE,

if( ID=FIRST_ID,

if(DOC_TYPE<>14, if(SOURCE_IDX<>7, ITEM)))))),ITEM)

Re: Problem with counting

mohamed_ahid — Tue, 21 Apr 2015 08:55:56 GMT

us only() function in this case .

can you send a sample file ?

Re: Problem with counting

Tue, 21 Apr 2015 09:15:16 GMT

USE THE LITTLE TABLE... I CANNOT GIVE THIS DATA

Re: Problem with counting

Tue, 21 Apr 2015 09:17:15 GMT

DOESN'T WORK

Re: Problem with counting

anbu1984 — Tue, 21 Apr 2015 10:59:48 GMT

Check this app