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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
roberto99
Contributor III
Contributor III

Problem Set Analysis exclud selection filter

I have this formula that works to exclude the value of filters, however it ignores one of them

Captura de pantalla 2019-08-15 a las 1.07.56.png 

Fail "Num_Doc=" 

Only Year selected, correct function

Captura de pantalla 2019-08-15 a las 1.06.45.png 

Num_Doc selected, the function fails

Captura de pantalla 2019-08-15 a las 1.07.21.png 

Thank you for helping
4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Please include the expression in question as text, not as an image. I cannot copy and edit from an image...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
roberto99
Contributor III
Contributor III
Author

Hi, this is the sintaxysis

 

sum({ $<[E_S]={'V'}, [Cod_Art]=, [Num_Doc]=,[Año]=,[Mes]=,[Dia]=, Tipo= > } Importe)

jonathandienst
Partner - Champion III
Partner - Champion III

Its a little hard to understand precisely what your problem is. 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
roberto99
Contributor III
Contributor III
Author

The problem is that if I select a Filter value “Num_Doc” the value of “Importe”  varies, and shouldn't  “Num_Doc=“.