Count distinct row

[maxime66]

Hi Qlikers,

Is there a simple expression to calculate distinct values for many columns ?

I'm looking for the result in "Distinct phone" row

Thanks for your time and help.

max.

[MK_QSL]

What is the result you are expecting?

[maxime66]

Hi Manish,

looking for result in "Distinct phone" row

[MK_QSL]

Like this?

[maxime66]

Result is good ,

but i would like not to touch my script ...

[sunny_talwar]

Non script way would be very complicated with if statements to check if the two columns have same value.

[maxime66]

We have to ask Qlikview to create a special count

=countvalueline(distinct (Row1,Row2 ...) )

[maxime66]

i found :

rangecount(expr1 [ , expr2, ... exprN ])

it's pretty much what i am looking for

but it seems that it doesn't work with  Distinct

[sunny_talwar]

Exactly that's what the issue is.... For distinct you will need some if statements

[maxime66]

Thanks anyway Sunny,

Let's Go for traditional IF(IF(IF(IF(IF 

have a good weekend