Discussion board where members can get started with Qlik Sense.
I want to unite 3 fields to one row.
For example :
I have the following 3 fields:
I want that after the calculated I will get 1 row with all the united values:
I prefer the calculated will be in the edit expression and not in the script...
I can see that done only in the script by using the crossTable and load distinct...
Can't see how it would be possible in the expression editor.
I don't see how this would be possible in the expression, you should do it in the script.
Not easy or practical to do in expression - much better in script.
LOAD ID1 as ID
LOAD ID2 as ID
Where Not Exists(ID, ID2)
LOAD ID3 as ID
Where Not Exists(ID, ID3)