Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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