Ignore Filters for one of the tables ?

[klrameet]

Hi

I have these two tables set of same data

A  (Current Filter, Status = Unmarried

Name	Address	DOB	Gender	Status
Adam	123 Abc St	01-01-1990	M	Unmarried
Brian	456 Def St	01-01-1991	M	Unmarried
Copper	789 Ghi St	01-01-1992	F	Unmarried

B

Name	Address	DOB	Gender	Status
Copper	789 Ghi St	01-01-1992	F	Unmarried

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 ?

[Vegar]

Take a look at my example picture and QVW file

[klrameet]

vegar.lie.arntsen‌ is there a different treatment for blanks ? coz i just realized that the issue i am facing is for the combination where the other field is blank and the additional field filter is not getting considered here

Name     Address          total

Adam     123 abc st       100

Eve        456 def st         110

David     789 ghi st         120

Nash                               130

Larry                                140

and when i try to default Nash & Lorrey, i am facing the problem .. my expression is :

if(getselectedcount([Name])=0,Sum([Total]),Sum({$<[Name]+={'Nash','Larry'},[Address]+={''}>}[Total]))

when I put this expression the defaulting of Adam & Nash which otherwise standalone works great, disappears and only shows data for selected name, instead of showing for three in total.

Appreciate your help.

[Vegar]

Yes there is an special treatment for "blanks"/"no value". Set analysis

simulates selections in your dataset hence you can only select values and

nselect Null() values in your Set modifiers.

A fix is to give your Empty addresses a value that is selectable, eg a

space ' '.

Cheers

VEGAR LIE ARNTSEN

Den tors 25 okt. 2018 15:49 skrev Amit Kaul <qcwebmaster@qlikview.com>:

Qlik Community <https://community.qlik.com/?et=watches.email.thread>

Ignore Filters for one of the tables ?

svar fra Amit Kaul

<https://community.qlik.com/people/klrameet?et=watches.email.thread> i *New

to Qlik Sense* - Se hele diskusjonen

<https://community.qlik.com/message/1563512?et=watches.email.thread#1563512>

[klrameet]

vegar.lie.arntsen  tried modifying it to include space.. but takes away the default rows entirely ..

My Expression:

if(getselectedcount([Name])=0,Sum([Total]),Sum({$<[Name]+={'Nash','Larry'},[Address]+={' '}>}[Total]))