topic Count Distinct of Selection in QlikView

Count Distinct of Selection

Mon, 04 Jul 2011 10:15:28 GMT

Hi!

i need to solve this problem...

In my Database( DB in example) i have ID with different STATUS (a or b) , a value variable € and Date (date of the status).

For each ID it is possible to have both Status or only one.

1- I need to count ID the have at least one record in Status a and one record in Status b.

2- For that ID i need to sum € only for status b. (in another words: It is important to have a total of € in status b but i've to consider only ID the have also one in status a).

It's a little bit complicate for me...

Thank you!!

Count Distinct of Selection

kaushiknsolanki — Mon, 04 Jul 2011 10:43:03 GMT

Hi,

Yes it is possible with set expression.

Create a straight chart with dimension as ID and expression as below.

sum({<ID = p ({<Status = {"A"}>}) * p ({<Status = {"B"}>}), Status = {"B"}>}€)

Regards,

Kaushik Solanki

Count Distinct of Selection

Mon, 04 Jul 2011 12:47:58 GMT

Thank you!!

Regards

Marco

Re: Count Distinct of Selection

Mon, 04 Jul 2011 12:48:41 GMT

Thank you!!

Regards

Marco