Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
elenarelinque
Creator
Creator

Reference Line obviating filters

How can I obviate the filters when I use a expression in the reference line?

This isn't working: =(Sum({$1<[Tipo documento]={'Abonos'}>}[Líquido albarán absoluto])/sum ({1}[Líquido albarán absoluto]))

 

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

You have 

Sum({$1<[Tipo documento] ...

I think you want to remove the dollar sign:

Sum({1<[Tipo documento] ...

View solution in original post

4 Replies
hic
Former Employee
Former Employee

You have 

Sum({$1<[Tipo documento] ...

I think you want to remove the dollar sign:

Sum({1<[Tipo documento] ...

elenarelinque
Creator
Creator
Author

Thank you so much! Do you know if there is any learning video regardin this topic (st analysis, st modifiers, etc).