topic Re: urgent in QlikView

urgent

Thu, 06 Feb 2014 11:22:50 GMT

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 — Thu, 06 Feb 2014 11:25:54 GMT

More information is needed.

Thanks.

Peter_Cammaert — Thu, 06 Feb 2014 11:28:49 GMT

Something like this?

=count(distinct Field1 & Field2 & Field3)

Best,

Peter

Thu, 06 Feb 2014 11:29:33 GMT

i think try this

count(distinct Rowno())

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

count( Rowno())

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

count(distinct Recno())

Sokkorn — Thu, 06 Feb 2014 11:29:57 GMT

Hi,

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

Can you share more info and what you looking for?

Regards,

Sokkorn

er_mohit — Thu, 06 Feb 2014 11:34:10 GMT

In expression side

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

or try this

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

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

Anonymous — Thu, 28 May 2015 08:45:58 GMT

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