Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dan205
Contributor III
Contributor III

How do you ignore a filter selection?

I have a filter where the field is =MonthName(SomeDateField).

How do I ignore this filter selection in an expression? 

This doesn't work:

=Sum({$<SomeDateField=>} [ColumnA])/Sum({$<SomeDateField=>} [ColumnB])

If I change $ to 1 it works but it also ignores all the other filters, which I don't want.

Thanks in advance,
Dan

Labels (2)
2 Replies
BrunPierre
Master
Master

Hi, you really don't need a set analysis in your case.  

An expression like this will disregard all other dimensions except those listed i.e. Dim1, Dim2 and Dim3

Sum(TOTAL <Dim1, Dim2, Dim3> [ColumnA]) / Sum(TOTAL <Dim1, Dim2, Dim3> [ColumnB])

Clever_Anjos
Employee
Employee

Try creating a field in your script using MonthName(SomeDateField) and then use this field to disregard the selection