Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
onkarkulkarni
Creator
Creator

ignore filter selection in table having only 2 dimensions, no measures.

Hi,

I am having a filter- employee and a straight table with 2 dimensions only - Region and country. no measures.

every employee belongs to a specific region and a country in that region. I need to display a table where a region (1st column) of the selected employee is displayed and a country (2nd column) shows all the countries mapped to the region (ignoring employee selection). so in short, employee selection should impact only Region dimension and not the country.

Hope I am clear with the requirement.

Regards,

OK

Labels (2)
1 Solution

Accepted Solutions
kashyap311996101
Partner - Specialist
Partner - Specialist

Hi 

First Create a variable like

vRegion 

=Concat(chr(39)&Region&chr(39),chr(44))

This will get the region based on employee selection and store it in a variable "vRegion"

 

Next create an Alternate state which u will find in master item like 'NoEmp'

 

Next Create a table with Region and Country

For region use this expression

=IF(Match(Region,$(vRegion)),Region)

Country  -  take as it is 

In Appearance section u will find alternate state their set it 'NoEmp'

Now if u select any employee the region will show for that particular employee and all the countries 

Note : if u dont want to show the countries where regions are not there just uncheck show null values from the region dimension

 

kashyap_0-1648621432414.png

 

I hope this resolve your issue 

 

Thanks and Regards

Kashyap.R

 

 

Thanks and Regards
Kashyap.R

View solution in original post

4 Replies
Vicky_Z
Support
Support

I believe set analysis expression can ignore the selection. find one example here: https://www.youtube.com/watch?v=eG4E5SwjFzE

onkarkulkarni
Creator
Creator
Author

Thanks Vicky, the example shows set analysis used in a measure to ignore selection but I need it in dimension (no aggregation). I can't use set analysis in dimension.

kashyap311996101
Partner - Specialist
Partner - Specialist

Hi 

First Create a variable like

vRegion 

=Concat(chr(39)&Region&chr(39),chr(44))

This will get the region based on employee selection and store it in a variable "vRegion"

 

Next create an Alternate state which u will find in master item like 'NoEmp'

 

Next Create a table with Region and Country

For region use this expression

=IF(Match(Region,$(vRegion)),Region)

Country  -  take as it is 

In Appearance section u will find alternate state their set it 'NoEmp'

Now if u select any employee the region will show for that particular employee and all the countries 

Note : if u dont want to show the countries where regions are not there just uncheck show null values from the region dimension

 

kashyap_0-1648621432414.png

 

I hope this resolve your issue 

 

Thanks and Regards

Kashyap.R

 

 

Thanks and Regards
Kashyap.R
onkarkulkarni
Creator
Creator
Author

Thanks a lot @kashyap311996101 , it's working as expected 🙂