Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Anonymous
Not applicable

Aggr set analysis

Hello Guys !

I want to make a expression, which need be fixed, even if i select a value. Here what i have:

FirstSortedValue (Distinct (Roteiro), -Aggr( count({1<evento={"Saida"}, Roteiro>}visitado) / count({1}Planejado) ,Roteiro))

So what i want is the first value. If i select something, it cant filter. I've tried to insert {1} in many places, but didnt worked.

How can we solve it?

Thanks !

1 Solution

Accepted Solutions
jerem1234
Valued Contributor II

Re: Aggr set analysis

Try putting it with firstsortedvalue like:

FirstSortedValue ({1}Distinct (Roteiro), -Aggr( count({1<evento={"Saida"}, Roteiro>}visitado) / count({1}Planejado) ,Roteiro))


Hope this helps!

2 Replies
jerem1234
Valued Contributor II

Re: Aggr set analysis

Try putting it with firstsortedvalue like:

FirstSortedValue ({1}Distinct (Roteiro), -Aggr( count({1<evento={"Saida"}, Roteiro>}visitado) / count({1}Planejado) ,Roteiro))


Hope this helps!

Anonymous
Not applicable

Re: Aggr set analysis

Hello Jeremiah Kurpat,

It worked. Thanks a lot !

Morandi