Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have two tables
Customer and Occupation which have 1 to many relation. I want to show output as final front end table..
Go to Solution.
The following should work:
Dimension 1: IDDimension 2: Name
Measure: MaxString(if(Year=year(today()), Type))
I'm using the MaxString() because Only() will show a null if there is more than one value. The if() statement is needed instead of using set analysis because you still want to show the blanks.
View solution in original post