Discussion board where members can get started with Qlik Sense.
my requirement to get distinct value from two columns. i need this in dimension expression
lets say my data rows will be look like this
Finally i need data look like below as single value in expression
please advise me how to get this
You can follow the idea presented in
It doesn't really matter if the field is holding dates or states, just create the link table as described.
i tried it but its showing syntax errors
How to write that in expression not in edit script
I (strongly) recommend that you prepare a link table in your model.