topic Re: set analysis in QlikView

set analysis

Tue, 13 Aug 2013 16:41:55 GMT

Hi everyone;

how i can to get this indicator? i need to remove in the dimension AutenticalUser: 'Redna\developerqv' and 'Redna\mmgarcia'

my actually formula

count ( { $ < Year = { $(= MAX(Year)) } >} SSessionStart)

i dont know the sintaxis to say differents in SET ANALYSIS OPERATOR

count ( { $ < AutenticalUser <>'Redna\developerqv' and AutenticalUser <>'Redna\mmgarcia' ,Year = { $(= MAX(Year)) } >} SSessionStart)

i understand this is wrong can you help me please?

Re: set analysis

jerem1234 — Tue, 13 Aug 2013 16:44:00 GMT

Try this:

count ( { $ < AutenticalUser -= {'Redna\developerqv', 'Redna\mmgarcia'} ,Year = { $(= MAX(Year)) } >} SSessionStart)

Re: set analysis

Tue, 13 Aug 2013 16:55:53 GMT

thanks very much the formula works but i have a question why still mark the formula the sintaxis as if wrong?

Re: set analysis

jerem1234 — Tue, 13 Aug 2013 17:01:25 GMT

I don't know the answer to that one, it always appears wrong for me as well. Maybe someone else on the community might know why that is. I would say it's a mistake on Qlikview's part, but I am not sure.

Re: set analysis

Tue, 13 Aug 2013 17:05:19 GMT

okay No problem anyway work it!!!

Thanks very much

Regards!!