Discussion Board for collaboration related to QlikView App Development.
HI guys,
Why the expression doesn't show the values for this filter by Only function and aggr function?
Hi, when a function retuirns more than one value you need a n aggregation funcion to return only one value.
Aggr() will return one value for each P, when there is a dimension with limits by one P value only one value of Co is shown, thats why is shown on rows, on totals rows aggr will return diffrent values, in example you can do a Concat():
Concat(Aggr(...), '","')
It will return one single value, a string that separates values using double quotes and a comma, wich inside the set analysis will use the starting and finishing double quotes to make a valid syntax.
Hi, when a function retuirns more than one value you need a n aggregation funcion to return only one value.
Aggr() will return one value for each P, when there is a dimension with limits by one P value only one value of Co is shown, thats why is shown on rows, on totals rows aggr will return diffrent values, in example you can do a Concat():
Concat(Aggr(...), '","')
It will return one single value, a string that separates values using double quotes and a comma, wich inside the set analysis will use the starting and finishing double quotes to make a valid syntax.