Discussion board where members can get started with Qlik Sense.
I want to count the unique customer that have more than 1 # Offered using expression. but some of the CSD. Formatted Number has different format.
(ie. tel:+61399389998;phone-context=national , tel:+61399389998) this should only be counted as 1 customer.
Go to Solution.
You might have left a closing parenthesis for the measure.
Also eustisab, if possible perform this transformation in the script like this
LOAD [CSD.Customer Formatted Number],
SubField([CSD.Customer Formatted Number], ';', 1) as RequiredString,
Once this is done, you can just use this
You can define the dimension in the table as:
And the measure as: