topic Re: Distinct count in QlikView

Distinct count

Wed, 16 Apr 2014 08:36:29 GMT

Hello,

I would like to do a count on the following excel sheet. I need to extract the number of "24 hours" cards, however as you can see, the card number 2402501 has 2 lines due to the fact that 2 activities has been linked to it.

how can I proceed ?

I can easily do this with a table but I need to have just one "text object". what could be the formula for this ?

thanks in advance for your help.

Re: Distinct count

Wed, 16 Apr 2014 08:39:58 GMT

Hi Jean,

Sorry mate, don't really get what your trying to accomplish here. Care to elaborate?

Best Regards,

Re: Distinct count

alexandros17 — Wed, 16 Apr 2014 08:40:58 GMT

Yes each card number has 2 lines but which one you need to select?

Re: Distinct count

arulsettu — Wed, 16 Apr 2014 08:45:52 GMT

try this

count(distinct K_Nummer)

Re: Distinct count

Wed, 16 Apr 2014 09:16:52 GMT

Hello

What I am trying to extract is the total number of 24h cards and the total number of 48h cards.

In my example, I should be able the find "4" as the number of 24h cards based on the fact that we 5 lines but the 2402501 has been used 2 times (same cards)

For the 48h card, I should be able to find "3". we have 6 lines but the card 4801622 has been used 4 times and therefore should count as 1 and the 2 others only 1 time.

is that more clear ?

thanks for your help.

Best

Re: Distinct count

yduval75 — Wed, 16 Apr 2014 09:31:44 GMT

You have to create a staitght table with K_Nummer in dimension and Count (DISTINCT KT_Bezeichnung) as expression

Re: Re: Distinct count

rajat2392 — Wed, 16 Apr 2014 09:38:43 GMT

check the app..I think this will solve the problem...

Re: Distinct count

Wed, 16 Apr 2014 12:08:14 GMT

this is what I have done....and I have a "0" result...

Re: Distinct count

tresB — Wed, 16 Apr 2014 12:15:58 GMT

Why [Card Number]? Your sample data says, it should be KT_Bezeichnung, like:

=Count({<KT_Bezeichnung={'24h*'}>}DISTINCT KT_Bezeichnung)

Or, if you want to count [Card Number], the expression has to be like:

Count({< [Card Number]={'24*'}>}DISTINCT [Card Number])