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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
User_BIT
Contributor
Contributor

Not exists in Set Analisys

Hello,

I need to replicate not exists function script in set analisys formula, I try:

=count({<fecha={">=$(=date(max(fecha)-90))<=$(=Max(fecha))"} ,tipo_user_generico={'operaciones'}>
- <balance={">0"} ,fecha={">=$(=Date(max(fecha)-90))<=$(=Date(max(fecha)))"}>
} DISTINCT userId)

Script vs set analisys give differents results, it's correct this formula?

thanks!

 

 

 

Labels (3)
1 Reply
JordyWegman
Partner - Master
Partner - Master

Hi,

It would be great if you can add some data while looking at this is a bit hard..

Jordy

Climber

Work smarter, not harder