Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
delbooth
Contributor II
Contributor II

Ignore filter selection in a table

Hi.

I have a filter of account names.  I also have a table that lists sales by month and when you select an account in the filter it only gives the sales for the selected account.  Is there a way in the set analysis of saying ignore the account name in a table measure column so you can get a total sales and sales for a selected company in one table.

I have tried

Sum({$<Year ="2018",[Account Name]=  , [Sales Code]={"S","R"}>} Sales) and

Sum({$<Year ="2018",[Account Name]=''  , [Sales Code]={"S","R"}>} Sales)

Filter selection set to Company A

Month   Sales   Total sales

Jan         100          250

Feb         80             150

                

Thanks

10 Replies
OmarBenSalem

Please;

Can u share a simple table of what u have and happens when u filter and another one of what u expect to happen as an output when u filter?

sunny_talwar

May be try this

Sum({$<Year = {"2018"}, [Account Name]=, [Sales Code] = {"S","R"}>} Sales)

delbooth
Contributor II
Contributor II
Author

Thanks.

I have tried it and

Sum({$<[Account Name]=>} Sales)


But it is still effected by the filter visualization

sunny_talwar

The filter field you are selecting is called Account Name or is it called something else?

delbooth
Contributor II
Contributor II
Author

Yep, called Account Name

Very strange as the way seems to be put [Account  Name]=

delbooth
Contributor II
Contributor II
Author

Hi.

It was because I was using a wildcard match

=if(wildmatch([Account Name],'*VAL*','*PIC*','*BACK*','ER*','*DH*','*ECO*'),[Account Name],Null())

Removing it and using just

[Account Name] works .  Now need to find a way of replicating :

=if(wildmatch([Account Name],'*VAL*','*PIC*','*BACK*','ER*','*DH*','*ECO*'),[Account Name],Null())

in my filter now so the ignore field element works.

Thanks

OmarBenSalem

Create it in the script as a new dimension and add it in ur expression

delbooth
Contributor II
Contributor II
Author

Thanks, could you explain what that means as I am still very new to Qlik Sense.

is it create it in the load script as a dimnsion ? and what would I use. 

Essentially I did the code below as I have large list of accounts but only want to have the 6 below in the filter to be selected

=if(wildmatch([Account Name],'*VAL*','*PIC*','*BACK*','ER*','*DH*','*ECO*'),[Account Name],Null())

sunny_talwar

Try this for filter

=Aggr(Only({<[Account Name] = {'*VAL*', '*PIC*', '*BACK*', 'ER*', '*DH*', '*ECO*'}>} [Account Name]), [Account Name])