Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If statement to Set analysis

Hi everyone,

i want to convert this if statement to set analysis.

sum (if(Jahr = year(today()) AND Warenfamilie <> 30 AND (UrsprungsAuftragstyp = 'UA' OR UrsprungsAuftragstyp = 'DI' OR UrsprungsAuftragstyp = 'UÄ' OR UrsprungsAuftragstyp = 'UT'), Umsatz, 0))  

I hope anybody can help me.

                         

1 Solution

Accepted Solutions
Gysbert_Wassenaar

sum({<Jahr={'$(=year(today()))'}, Warenfamilie -={30}, UrsprungsAuftragstyp={'UA','DI','UÄ','UT'} >} Umsatz)


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

sum({<Jahr={'$(=year(today()))'}, Warenfamilie -={30}, UrsprungsAuftragstyp={'UA','DI','UÄ','UT'} >} Umsatz)


talk is cheap, supply exceeds demand
Not applicable
Author

It works great!

Thank you very much Gysbert Wassenaar for the quick answere!