Issue while selecting Data

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

State

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

Re: Issue while selecting Data

MK9885 — Fri, 21 Oct 2016 16:46:14 GMT

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.

topic Re: Issue while selecting Data in QlikView

Issue while selecting Data

Re: Issue while selecting Data