Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!!