Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Ignore Filters for one of the tables ?

Hi

I have these two tables set of same data

A  (Current Filter, Status = Unmarried

NameAddressDOBGenderStatus
Adam123 Abc St01-01-1990MUnmarried
Brian456 Def St01-01-1991MUnmarried
Copper789 Ghi St01-01-1992FUnmarried

B

NameAddressDOBGenderStatus
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
Highlighted
Partner
Partner

Re: Ignore Filters for one of the tables ?

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...

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

13 Replies
Highlighted
Partner
Partner

Re: Ignore Filters for one of the tables ?

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...

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Ignore Filters for one of the tables ?

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)

Highlighted
Partner
Partner

Re: Ignore Filters for one of the tables ?

yes you can do as below:

sum( {< Gender, Address >} your_measure_field)

I hope it helps.

Highlighted
Master II
Master II

Re: Ignore Filters for one of the tables ?

Maybe

For Table A:

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

For Table B:

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

Highlighted
Partner
Partner

Re: Ignore Filters for one of the tables ?

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor III
Contributor III

Re: Ignore Filters for one of the tables ?

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

Highlighted
Master II
Master II

Re: Ignore Filters for one of the tables ?

Did you try with getselectedcount?

if(getselectedcount(Name)=0,

Sum({$<[Name]={Adam}>}[Total]),

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.

Highlighted
Partner
Partner

Re: Ignore Filters for one of the tables ?

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

Try this expression:

Sum({$<[Name]+={'Adam'}>}[Total])

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor III
Contributor III

Re: Ignore Filters for one of the tables ?

Hi vegar.lie.arntsen

this is works perfect. But if i make a selection on address alone with name, the data for adam goes away again .. i tried to modify it as

Sum({$<[Name]+={'Adam'},[Address]+={'123 Abc St'}>}[Total])


but this doesn't work, am i missing on something ?