urgent

[#1]

I have load entire table data on dashboard.

What i want now is count of rows where 3 fields are distinct.

How do i get it in qlikview?

[Anonymous]

More information is needed.

Thanks.

[Peter_Cammaert]

Something like this?

     =count(distinct Field1 & Field2 & Field3)

Best,

Peter

[#4]

hi

i think try this

count(distinct Rowno())

*********************

count( Rowno())

*****************************

count(distinct Recno())

[Sokkorn]

Hi,

Maybe like this: =Count(Distinct <Field1,Field2,Field3> ID)

Can you share more info and what you looking for?

Regards,

Sokkorn

[er_mohit]

In expression side

count(aggr(Rowno(),Field1,Field2,Field3)

or try this

count(distinct<Field1,Field2,Field3>ID)

or

count(aggr(Nodistinct Rowno(),Field1,Field2,Field3)

[Anonymous]

HI,

Do you want to count the number of rows when the content of the 3 fields are different?

If so, try this:

Creat a table graph with your three fields as dimension and the expression will be:

sum(if(Field1<>Field2 and Field2<>Field3 and Field1<>Field3,1,0))

The total of this expression will be the count you are looking for