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: 
Not applicable

Issue while selecting Data

Hi,

My requirement is following. Let’s assume the below data.

State

HR

MH

City

HR-Chd

HR-Roh

MH-Mum

MH-Pu

MH-Nag

Town

HR -A

HR –B

MH-A

MH-B

MH-C

               

Table Box Data:

AA

BB

CC

HR

AA

State

HR-Chd

BB

City

HR-Roh

CC

City

HR -A

DD

Town

HR –B

AA

Town

MH

BB

State

MH-Mum

CC

City

MH-Pu

EE

City

MH-Nag

GG

City

MH-A

HH

Town

MH-B

CC

Town

MH-C

AA

Town

If I click on Listbox (State) value = HR, then the data would be display like below:

AA

BB

HR

AA

If again I click on Listbox (City) value = HR-Chd, then the data would be display like below:

AA

BB

HR

AA

HR-Chd

DD

If again I click on Listbox (City) value = HR –A, then the data would be display like below

AA

BB

HR

AA

HR-Chd

DD

HR –A

DD

To achieve this functionality, I put event field trigger on ListBox selection (CC field).

If I am selecting the data from Listbox one by one, the data is displaying correctly in Table Box. If I go from TableBox to ListBox then the data is not displaying correctly. I am getting other data which is not based on the filter in the Table Box.

If I click on HR value from Table Box Data:

AA

BB

CC

HR

AA

State

HR-Chd

BB

City

HR-Roh

CC

City

HR -A

DD

Town

HR –B

AA

Town

MH

BB

State

MH-Mum

CC

City

MH-Pu

EE

City

MH-Nag

GG

City

MH-A

HH

Town

MH-B

CC

Town

MH-C

AA

Town

Then I am getting the below data:

AA

BB

CC

HR

AA

State

After that, if I click on Listbox2(City) value = HR-Chd then the above mentioned data gone and I am getting all the data belongs to City but I want only the below mentioned data in this case.

AA

BB

CC

HR

AA

State

HR-Chd

BB

City

I need to display the data based on the Hierarchy. Can you please let me know what I am missing and how to achieve this functionality?

Thanks & Regards:

Amit Jain

1 Reply
MK9885
Master II
Master II

I'm not sure and if i'm wrong maybe an expert can correct me.

What you can do is, add the following conditions to your dimensions

If (AA=AA,0,CC) >>> For AA Dimension

If(BB=BB,0,CC)>>>> For BB Dimension

the above 2 conditions should be given in your chart. Not in your List Box.

So if you select a value from List box 'AA' , EX: HR then it will show you all columns but not CC

CC will be hidden and will only be visible upon selecting the AA or BB value in your table..

Here we're hiding the CC column from users and will be available upon selection.

Make a Straight table, it will be better for users. All values will be visible regardless of selection but upon selecting filters AA of BB the CC will hide.

Thanks.