Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count with 3 Value in 1 Dimension fulfill

Dear All,

Can anybody help for one case that i facing   

Case :

i want to count how many people that bought all PEN , BOOK and ERASER  (if they bought BOOK and ERASER, not counted)

and have to be distinct.

the correct answer should be = 2 --> A and D

DATENAMEITEMQTY
1-NovABOOK1
1-NovAPEN1
1-NovBERASER1
1-NovBBOOK1
1-NovCBOOK1
2-NovAERASER1
2-NovDBOOK1
2-NovDPEN1
2-NovDERASER1
2-NovEMAGAZINE1
2-NovEMAGAZINE1
2-NovDBOOK1

Thanks in advance

1 Solution

Accepted Solutions
swuehl
MVP
MVP

=COUNT({<NAME = p({<ITEM= {'PEN'}>})*p({<ITEM= {'BOOK'}>})*p({<ITEM= {'ERASER'}>}) >}DISTINCT NAME)

or

=COUNT({<NAME = {"=COUNT({<ITEM = {'PEN','BOOK','ERASER'}>}DISTINCT ITEM)=3"}>} DISTINCT NAME)

View solution in original post

2 Replies
swuehl
MVP
MVP

=COUNT({<NAME = p({<ITEM= {'PEN'}>})*p({<ITEM= {'BOOK'}>})*p({<ITEM= {'ERASER'}>}) >}DISTINCT NAME)

or

=COUNT({<NAME = {"=COUNT({<ITEM = {'PEN','BOOK','ERASER'}>}DISTINCT ITEM)=3"}>} DISTINCT NAME)

View solution in original post

Not applicable
Author

thanks a lot swuehl. the formula is correct and giving the right result.

can i know what is "p" stand for ?