Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have the following Table :
And i have the following Code :
If(not WildMatch(Name,'D*'),'Exclude Initial D') as Name_Selection
FROM Table_Names_Desc ;
'Exclude Name' as Name_Selection
Where Name <> 'Adam' and Name <> 'Kevin' and Name <> 'Ryan';
'All Names' as Name_Selection
So now if i select a Filter Pane "Name_Selection", I will have 3 selections:
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
Also Check if the code is Working correctly or some changes are to be made to the code.
Thanks in Advance.
May be look here for AND-MODE in Qlik Sense
Generating AND, OR , NOT selection logic in Qlik Sense
For QlikView it is simple....
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.
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 ??
Would you be able to share your qvf or a sample qvf showing the issue?
Here, i have attached a sample .qvf
Just check and let me know if anything can be done.