topic Please Help Count/Distinct Count in QlikView

Please Help Count/Distinct Count

Thu, 25 Jun 2015 20:54:54 GMT

Hi,

I have a table with two columns (see below)

I need to calculate the total number of distinct items and also calculate total number of completed Distinct items (Status = 1)

eventually i need a percentage representation.

Please help me figure this requirement. Thank you for your time and help.

Best,

Nik

Anonymous — Thu, 25 Jun 2015 20:59:57 GMT

1. count (distinct Item)

2. count ({<Status={1}>} distinct Item)

Thu, 25 Jun 2015 21:04:29 GMT

Hi Michael,

Thank you, I kept trying different variations of the 2nd option. Wasnt aware that we can have different fields.

Does {<Status = {1}>} act as a conditional if?

Thanks again for your time.