Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Take a look at my example picture and QVW file
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.
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>
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]))