Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis

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?

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

Try this:

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

View solution in original post

4 Replies
jerem1234
Specialist II
Specialist II

Try this:

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

Not applicable
Author

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

jerem1234
Specialist II
Specialist II

     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.

Not applicable
Author

okay No problem anyway work it!!!

Thanks very much

Regards!!