count distinct <>'0'

Aika — Thu, 02 Sep 2021 09:47:03 GMT

Hi,
how to add to this string (applied on a qlik map):
Count (distinct {<debtor_name1 = {'= Count (Distinct main_status_code) = 1 and main_status_code = 6'}>} debtor_name1)

the condition that if the count distinct is = 0 it must not appear on the map?

Thank you!

Re: count distinct <>'0'

edwin — Wed, 15 Sep 2021 11:33:25 GMT

Count (distinct {<debtor_name1 = {"= Count (Distinct {<main_status_code = {6}>}main_status_code) = 1"}>} debtor_name1)

Count (distinct {<main_status_code = {6}, debtor_name1 = {"= Count (Distinct main_status_code) = 1"}>} debtor_name1)

1st, use double quotes, next the placement of main status code check will depend on which condition you wanted to apply it on. either on the check for uniqueness or on the overall expression

topic count distinct <>'0' in QlikView

count distinct <>'0'

Re: count distinct <>'0'