topic Re: To display a particular column based on filter selection in grid in QlikView

To display a particular column based on filter selection in grid

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Consider I have the following list box and grid chart(Straight Table),

ListBox1:

Clients
A
B

ListBox2:

Country
USA
India

Grid:

Client Name	Country
A	USA
B	India

Now if I select Client in the list box,the grid should only show the Client Name column in the grid and others should not be shown. So based on the filters selection I want the grid columns to be shown. And also by default I want to show all the columns in the grid and only if I select a filter, I want the grid(Straight Table) to be displayed based on the filter(listbox) selection. I don't want to show based on hide/show option.

Re: To display a particular column based on filter selection in grid

Digvijay_Singh — Mon, 15 May 2017 17:06:31 GMT

Use these condition in Dimension enable condition -

GetSelectedCount([Clients])=1 or GetSelectedCount(Country)=0

GetSelectedCount(Country)=1 or GetSelectedCount([Client])=0

Re: To display a particular column based on filter selection in grid

Digvijay_Singh — Mon, 15 May 2017 17:09:04 GMT

Use '>=1' to handle multiple selections in above expressions

Re: To display a particular column based on filter selection in grid

ziadm — Mon, 15 May 2017 17:13:46 GMT

if you have the right data model then the Qlik by default will filter the associated data only. This is called associative experience.

The Associative Experience - Revisited

Re: To display a particular column based on filter selection in grid

Mon, 15 May 2017 18:53:52 GMT

It works in case of 2 columns and filters but in actual data I have more than 10 columns

Re: To display a particular column based on filter selection in grid

Mon, 15 May 2017 18:59:52 GMT

Yup I knew Qlik is associative in nature but here my question is to display only the columns that is selected in list box. For e.g. If I select Country USA from List box, I just want Country column to be displayed in grid by excluding Client Name.

Re: To display a particular column based on filter selection in grid

Digvijay_Singh — Mon, 15 May 2017 19:44:11 GMT

The solution is simple, it appear long, you just need to add the rest of the dimensions as below -

GetSelectedCount([Clients])>=1 or (GetSelectedCount(Country)=0 and GetSelectedCount(Region) = 0)

Re: To display a particular column based on filter selection in grid

Mon, 15 May 2017 20:06:19 GMT

Ya thank you. It worked..

Re: To display a particular column based on filter selection in grid

Digvijay_Singh — Mon, 15 May 2017 20:09:29 GMT

Good. You can close this thread by marking appropriate answer correct or can post new questions.

Re: To display a particular column based on filter selection in grid

Matt — Tue, 26 Feb 2019 07:50:12 GMT

Hello Digvijay, I have same problem. My table contains dimensions and expressions as columns. For example dimensions Bank, manager, contract_type, contract_category, year and expressions total_contracts, contract_y_2018, contract_y_2019.

If I select Bank = 'ABC' and year = '2019' I want to display all dimensions and expressions only total_contracts, contract_y_2019

Could you help me, please?