Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ivandrago
Creator II
Creator II

How to ignore certain filters

Hi,

I have a counter on my dashboard and list of filters, basically I want the counter to ignore certain filters when user clicks on it, is this possible?

count({$<[Type]={'OPEN'}>} DISTINCT [SalesNo])

I did try changing th $ to a 1 but it ignores all filter selections.

Thanks

Ivan

2 Replies
Not applicable

Hi,

I had same doubt...

You can use like this

Sum({$<Year={$(=Only(Year)-1)},Month=>} VentasNetas)

Where I ignore a dimension Month....

Not applicable

Yes. To ignore a certain fields selection, put it in your Set Analysis without a Set Modifier. Like:

count({$<[Type]={'OPEN'}, [IgnoreThis]=>} DISTINCT [SalesNo])


You can keep the dollar sign, because you want to respect the other selections.