topic Intersection of data in QlikView

Intersection of data

manojkulkarni — Mon, 24 Aug 2015 06:38:24 GMT

Hi All,

Have below data. I need to plot table showing how many users answered Yes for both the questions, # of users Yes for QnID 1 & QnID 2. How can we \achieve this ?

DT	User	QnID	Col3
1/20/2015	1	1	Yes
1/20/2015	1	2	No
1/20/2015	2	1	Yes
1/20/2015	2	2	Yes
1/20/2015	3	1	Yes
1/20/2015	3	2	No
1/20/2015	4	1	Yes
1/20/2015	4	2	Yes
1/20/2015	5	1	Yes
1/20/2015	5	2	No

Re: Intersection of data

tresB — Mon, 24 Aug 2015 06:58:53 GMT

Yes for both questions, no of users:

=Count(DISTINCT{<User={"=Count(Distinct {<Col3={Yes}>}QnID)=2"}>}User)

Re: Intersection of data

petter — Mon, 24 Aug 2015 07:13:15 GMT

In a chart where you include the User as a dimension and each user has only one row you can use this

expression:

-(Count({<Col3={'Yes'}>} User )=2)

This will return a true or false value ( -1 or 0 ) and the zero values will be eliminated as default. The minus one will be converted to a 1 indicating that you have a match.

If( Count({<Col3={'Yes'}>} User)=2 , 'Both Yes' )

Will also do the trick but with a more sensible return value.

Re: Intersection of data

Digvijay_Singh — Mon, 24 Aug 2015 08:48:53 GMT

See below based on already shared expressions by others...