Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jsobrinho
Creator
Creator

Only function aggr inside set analysis

HI guys,

Why the expression doesn't show the values for this filter by Only function and aggr function?

Only help.png

Labels (1)
1 Solution

Accepted Solutions
rubenmarin

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.

View solution in original post

1 Reply
rubenmarin

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.

View solution in original post