topic Re: Help in QlikView

Help

Tue, 06 Jan 2015 07:09:31 GMT

Hello All,

I want the count of enployee who whose Answer is Contact No and Email Id(Both)

ie ouput should be 5

Voterid	Question	Answer
1	Contact Details	Contact No
2	Contact Details	Email ID
3	Contact Details	Name
4	Contact Details	Email ID
4	Contact Details	Name
5	Contact Details	Contact No
5	Contact Details	Email ID

Regards,
priya

Re: Help

nikhilgarg — Tue, 06 Jan 2015 07:38:03 GMT

Use the following Expression:

Count({<Answer = {'Contact No' , 'Email ID'}>}Answer)

Re: Help

Colin-Albert — Tue, 06 Jan 2015 07:50:25 GMT

You need to count the distinct Voterid's so the value returned is 1 for the two entries of Contact No and Email Id.

Count({<Answer = {'Contact No' , 'Email ID'}>} distinct Voterid)

Re: Help

jagan — Tue, 06 Jan 2015 07:52:25 GMT

Hi,

Try this expression

=Count({<Voterid ={"=Count({<Answer ={'Contact No', 'Email ID'}>} DISTINCT Answer) =2"} >} Distinct Voterid )

Regards,

Jagan.

Re: Help

mdmukramali — Tue, 06 Jan 2015 08:00:51 GMT

Dear ,

if you want to perform AND operation

use the below expression.

=Count(DISTINCT{<Voterid=p({1<Answer={'Contact No'}>})*p({1<Answer={'Email ID'}>} Voterid)>}Voterid)

Thanks,

Mukram

Re: Help

nikhilgarg — Tue, 06 Jan 2015 09:31:27 GMT

Hey ,

I didn't understand why you count Distinct Answer and equals to 2 ??

Cann't we do like : Count({<Answer = {'Contact No' , 'Email ID'}>} distinct Voterid)

Re: Help

jagan — Tue, 06 Jan 2015 09:40:00 GMT

Hi Nikhil,

Here the concept is for each voterid, there should be both the entries 'Contact No' , 'Email ID'.

So only voterid 5 has both.

Regards,

Jagan.

Re: Help

nikhilgarg — Tue, 06 Jan 2015 09:50:01 GMT

HEy,

In your expression :

Count({<Answer ={'Contact No', 'Email ID'}>} DISTINCT Answer) will return 2. Ryt ??

then , what will below return :

<Voterid ={"=Count({<Answer ={'Contact No', 'Email ID'}>} DISTINCT Answer) =2"}> ??

THanks

Re: Help

jagan — Tue, 06 Jan 2015 10:02:35 GMT

Hi,

If a voterid give 'Contact No', 'Email ID' answers then for that voter id we will get the count as 2.

<Voterid ={"=Count({<Answer ={'Contact No', 'Email ID'}>} DISTINCT Answer) =2"}>

Here we are filtering the voterids who has given both 'Contact No', 'Email ID' (not any one) answers.

Regards,

Jagan.

Re: Help

nikhilgarg — Tue, 06 Jan 2015 10:11:33 GMT

Ok , Got it . But I didn't know that we can put set analysis like this also that on left side Field Name is there and right side Another field name to compare the value.

I usually put the analysis like:

On left side Filed Name and on right side either a numerical value or String.