topic Aggr set analysis in QlikView

Aggr set analysis

Anonymous — Fri, 19 Sep 2014 18:51:10 GMT

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 !

jerem1234 — Fri, 19 Sep 2014 20:13:49 GMT

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 — Mon, 22 Sep 2014 12:22:58 GMT

It worked. Thanks a lot !

Morandi