Including Values Intersecting to Selections in Filter of Qlik Sense.

[satish25]

Hello Everyone,

I have the following Table :

Name
Adam
Bob
Charles
Dean
Danny
Derrick
Evan
Kevin
Liam
Max
Ryan
Stan

And i have the following Code :

Table:

LOAD

  Name,

    If(not WildMatch(Name,'D*'),'Exclude Initial D') as Name_Selection

FROM Table_Names_Desc ;

Concatenate(Table)

LOAD

Name,

    'Exclude Name' as Name_Selection

FROM Table_Names_Desc

Where Name <> 'Adam' and Name <> 'Kevin' and Name <> 'Ryan';

Concatenate(Table)

LOAD

    Name,

    'All Names' as Name_Selection

FROM Table_Names_Desc ;

So now if i select a Filter Pane "Name_Selection", I will have 3 selections:

• Exclude Initial D.
• Exclude Name.
• All Names.

So the issue that I am facing is that if I select Both 'Exclude Initial D' & 'Exclude Name',

since there is nothing common between these values, it shows all the Names

However i want it to show the Names Intersecting to both i.e. the values for the following selections should be

• Exclude Initial D. : Adam, Bob, Charles, Evan, Kevin, Liam, Max, Ryan, Stan.
• Exclude Name. : Bob, Charles, Dean, Danny, Derrick, Evan, Liam, Max, Stan.
• Exclude Initial D. & Exclude Name. : Bob, Charles, Evan, Liam, Max, Stan. (Intersection of The Top 2 Selections).
• All Names. : Adam, Bob, Charles, Dean, Danny, Derrick, Evan, Kevin, Liam, Max, Ryan, Stan.

Also Check if the code is Working correctly or some changes are to be made to the code.

Thanks in Advance.

[sunny_talwar]

May be look here for AND-MODE in Qlik Sense

Generating AND, OR , NOT selection logic in Qlik Sense‌

For QlikView it is simple....

AND-Mode

[marcus_sommer]

I think it won't be possible with the normal working of the associative logic behind the selections. Within QlikView there is a special feature called AND-Mode with which something like this might be possible. I'm not sure if this is available within Sense - the following: https://help.qlik.com/en-US/sense/April2018/APIs/EngineAPI/services-Field-GetAndMode.html looked different respectively needs to be implement on your own.

More easier would be to create your intersection as an own "Name Selection" - there would be now 4 entries and this could be achieved by additionally loading your excluding parts, (inner) joining them and concatenate this result to the other.

- Marcus

[satish25]

Hi Sunny,

Thanks for your reply

However this is in a bar chart.

My data is in tabular form and this field isn't there in the table.

On the selection of this filter the tabular values change.

So is there any way out to this ??

[sunny_talwar]

Would you be able to share your qvf or a sample qvf showing the issue?

[satish25]

Here, i have attached a sample .qvf

Just check and let me know if anything can be done.