Ignore all filters but keep one

[Anonymous]

Is there a way to ignore all filters and keep one ?

sum(CA)

[lironbaram]

yes

you can do it for example you want only the country filter you do it like that

sum({1<country=p(country)>}CA)

[Anonymous]

I need to calculate YTD

Sum({< Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)

IT WOULD BE sum({1<Date=P{‘>=$(=YearStart(Today()))<=$(=Today())’}>}CA) ? I got always error

[Anonymous]

hi,

Try:

Sum({<Year=,Month=, Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)

[Anonymous]

I have a lot of other fiilters in the other sheets how can I ignore them ?

[lironbaram]

Sum({1< Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)

[jagan · Accepted solution]

HI,

Try like this

=Sum({1< Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} CA)

Regards,

Jagan.

[maxgro]

this is an interesting answer to your question

Ignore all selections except some specific fields using Set Analysis

[qlikviewwizard]

Hi,

Please try like this. Hope this will Helpful to you. Thank you.