Announcements
cancel
Showing results for
Did you mean:
Contributor III

## Ignore Filters for one of the tables ?

Hi

I have these two tables set of same data

A  (Current Filter, Status = Unmarried

Brian456 Def St01-01-1991MUnmarried
Copper789 Ghi St01-01-1992FUnmarried

B

Copper789 Ghi St01-01-1992FUnmarried

So, When filter selected on Gender, currently both the tables are showing filtered values (like here in table B) but I only want this additional filter on gender to be only applied to table B,ie. Status = Unmarried + Gender = F

while table A continue to show All the records, based on the other original filter on Status = Unmarried

How can i achieve this ?

1 Solution

Accepted Solutions
MVP

If you have expression columns you should add a SET canceling the selection of Gender. If you don't have an expression  then you will need to create one.

EG:

sum({\$<Gender>} Something)

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetA...

13 Replies
MVP

If you have expression columns you should add a SET canceling the selection of Gender. If you don't have an expression  then you will need to create one.

EG:

sum({\$<Gender>} Something)

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetA...

Contributor III
Author

thanks vegar.lie.arntsen‌ ..

this worked like a charm ... is there a way i can exclude filters for multiple columns ..

e.g. sum( {\$<Gender= > and \$<Address= >} XXX)

Partner - Champion

yes you can do as below:

sum( {< Gender, Address >} your_measure_field)

I hope it helps.

Master II

Maybe

For Table A:

Count({< Status={'Unmarried'}>}Name)

For Table B:

Count({<Gender={'F'},Status={'Unmarried'}>}Name)

MVP

Set analysis is a powerful part of QlikView and Qlik Sense. I recommend you to look into it. LivingQlik Roots: The Ultimate QlikView Set Analysis Reference could be a good place to start I addition to the Qlik help page I referred to earlier.

Contributor III
Author

vegar.lie.arntsenshahbazkhan‌ .. is it possible to set modifiers in such a way that they work with current selection and some default condition as AND ..

E.g I want to display total for selected name (this selection can change) and for Adam (always) .. I tried using Sum({\$<[Name]={Adam}>}[Total]), but this only returns total for Adam, ignoring the current selection... any ideas plz

Master II

Did you try with getselectedcount?

if(getselectedcount(Name)=0,

Sum(Total))

This would work if by default or without any selection you like to just see Adam but if you select others it would show others and also Adams if selected.

MVP

Yes there is a syntax for using selected values + a default set.

Try this expression: