Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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=“.