topic Re: What does this expression do? in QlikView

What does this expression do?

Fri, 07 Sep 2012 05:57:38 GMT

I´ve come across this expression in an old qv file I made some time ago - I think I´ve got some help here at that time but I cant figure out

what it actually do

=count(distinct name & 'l' & age)

name and age are fieldnames in a spreadsheet

Fri, 07 Sep 2012 06:30:20 GMT

Hi,

this creates concatenation of two field values name, age and | char and counts distinct number of such created strings.

regards

jvitantonio — Fri, 07 Sep 2012 07:39:12 GMT

This will return the distinct count of your concatenated field Name and Age. Let's suppose you have the following names and ages:

NAME - AGE

Peter - 20

Maria - 28

Julio - 26

Now, the result of name& '|' &age is:

Peter|20

Maria|28

Julio|26

The count distinct of this is 3 (because Peter|20 is repeated twice).

I hope this helps.-

jagan — Fri, 07 Sep 2012 07:40:43 GMT

Hi,

This will count the distinct number of concatenated name and age fileds and separated by '|' character.

Hope this helps you.

Regards,

Jagan.