topic Re: How to pass variable into TableBox as filter in QlikView

How to pass variable into TableBox as filter

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to QlikView and got stuck in one scenario. Let’s assume, this is the data I have in my Oracle table. I cannot share the exact data due to security reason.

S_CODE	C_CODE	SI_CODE	TYPE	E_CODE
A	COU_A	A_1	STU	A
A	COU_A	A_1	COU	COU_A
A	COU_A	A_1	SI	A_1

I created 3 Listbox for S_CODE, C_CODE and SI_CODE and displaying the complete set of data in TableBox.

ListBox 1

S_CODE

ListBox 2

C_CODE

COU_A

ListBox 3

SI_CODE

A_1

Data in Tablebox:

S_CODE	C_CODE	SI_CODE	TYPE	E_CODE
A	COU_A	A_1	STU	A
A	COU_A	A_1	COU	COU_A
A	COU_A	A_1	SI	A_1

If I Click on ListBox1,ListBox2 or ListBox3, I got all the 3 records in TableBox instead of 1 record. My requirement is:,

If I click on ListBox1 value(A) the data should be display:

S_CODE	C_CODE	SI_CODE	TYPE	E_CODE
A	COU_A	A_1	STU	A

If I click on ListBox2 value(COU_A) the data should be display:

S_CODE	C_CODE	SI_CODE	TYPE	E_CODE
A	COU_A	A_1	STU	COU_A

If I click on ListBox3 value(A_1) the data should be display:

S_CODE	C_CODE	SI_CODE	TYPE	E_CODE
A	COU_A	A_1	STU	A_1

Can you please help me out, how I will get only one record by clicking on ListBox? Is there any way to make a join of ListBox Field selection value with column (E_CODE).

I tried to capture the ListBox Field selection value in variable but don’t know how to pass this variable value into TableBox? Please let me know in-case any additional information required.

Any help regarding this would be really appreciated. Thank You.

Regards:

Amit Jain

Re: How to pass variable into TableBox as filter

adamdavi3s — Mon, 10 Oct 2016 07:51:37 GMT

You could add a document trigger for each of the fields which also triggers the same selection in E_CODE

You could use a chart table instead of a table box which doesn't have many options

Otherwise, why don't you just have a list box for E_CODE?!

Re: How to pass variable into TableBox as filter

Mon, 10 Oct 2016 08:32:27 GMT

Hi Adam,

Thank You for the reply !

I can 't use E_CODE as I have to generate the hierarchy in the LISTBOX so the USER gets to know which data is associated in LISTBOX2 and LISTBOX3 by clicking on LISTBOX1.

I will try your approach with document trigger and chart table. As i am new to QlikView, Can you please explain in detail, How i can create a document trigger and how i can pass this value?

Thanks & Regards:

Amit Jain

Re: How to pass variable into TableBox as filter

Anil_Babu_Samineni — Mon, 10 Oct 2016 09:31:27 GMT

No need to create a variable here, Your title mentioned variable, Where do you create the variable.

Re: How to pass variable into TableBox as filter

Mon, 10 Oct 2016 09:37:36 GMT

Hi Anil,

I created the variable in LOAD script and then able to call the same variable in TextBox but not able to pass this variable as a filter in TableBox. I hope you understand the point, Please let me know in-case of any question.

Thanks & Regards:

Amit Jain

Re: How to pass variable into TableBox as filter

Anil_Babu_Samineni — Mon, 10 Oct 2016 11:37:57 GMT

Is there any chance share the applicaiton. What is variable you've created. And somehow, Table box never taken the Variable this situation you might create one more Straight table / Pivot

Re: How to pass variable into TableBox as filter

adamdavi3s — Mon, 10 Oct 2016 11:41:42 GMT

I am still confused as to why you can't just use E_CODE as a filter?

Re: How to pass variable into TableBox as filter

adamdavi3s — Mon, 10 Oct 2016 11:44:08 GMT

Hi Amit,

OK I see what you are saying now... just go to settings > document properties > triggers

Then use the field event triggers and add an onselect trigger for each listbox.

I would also add an onChange to make sure you update E_CODE if the user changes the selection.

Re: How to pass variable into TableBox as filter

adamdavi3s — Mon, 10 Oct 2016 11:51:01 GMT

The attached example has a trigger set up on S_CODE

Re: How to pass variable into TableBox as filter

Mon, 10 Oct 2016 11:53:21 GMT

Thank You Adam for your prompt reply. I am able to achieve the scenario from your solution. I created Field Event Triggers on Selection and it works.

Many Thanks !