Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selected values from listbox should be displayed in tablebox or straight table

Hi ,

I have attached a sample file along with this post.

what my requirement is

I have listboxes like this

T1:      A:      B:      C:

A         1       4       7

B         2       5       8

C         3       6       9

If I may select from T1 either A/B/C or A,B/B,C/C,A or A,B,C.

Now I want to to display only the selected columns along with those values in a seperate tablebox or Straight table.

I think you understand my explanation and what i want.

Note: My system is not having the full version. so,please send details with explanation.

is it possible to do like that?

Can any one help in this?

Thanks.....

6 Replies
Not applicable
Author

Hi,

Check the attached file...

Not applicable
Author

Hi Shans,

thanks for your response.

Sorry to say this , that my system doesn't have fullversion.So, i am not able to open your file.

Can you please send me the logic briefly .

Thanks....

Not applicable
Author

We can implement your requirement in straight table using the conditional show option

1. Cretae a Staright table with A, B, C and an dummy expression like 1

2. Then use conditional show to hide or display the selected column like

For A -wildmatch(getfieldselections(T1),'*A*')

For B -wildmatch(getfieldselections(T1),'*B*')

For C -wildmatch(getfieldselections(T1),'*C*')

Not applicable
Author

Hi,

Create a Straight table.

In that take Dimensions as A,B,C.

Expression as 1

Then go to presentaion tab:

In that For A Column:

Choose the conditional Option and use this Expression:

if(index(concat(distinct T1), 'A')<>0, 1, 0)

For B Column:

Choose the conditional Option and use this Expression:

if(index(concat(distinct T1), 'B')<>0, 1, 0)

For C Column:

Choose the conditional Option and use this Expression:

if(index(concat(distinct T1), 'C')<>0, 1, 0)

Not applicable
Author

Hi Shans,

Thanks for your response

You came clouser to my requirement

What exactly i want is What ever i select from A,B,C should be displayed in the straight table .

Like this

If I am selecting 1 from A, 6 from B, 8 from C.

Then table should be displayed as

A    B   C

1    6    8

But here it displayed Here i am checking A,B,C and whatever i select from A/B/C those corresponding values from other listboxes are displayed.

Hope so you understand...

Is it possible to do like that?

Thanks...

Not applicable
Author

Hi Jain,

Thanks for your response

You came clouser to my requirement

What exactly i want is What ever i select from A,B,C should be displayed in the straight table .

Like this

If I am selecting 1 from A, 6 from B, 8 from C.

Then table should be displayed as

A    B   C

1    6    8

But here it displayed Here i am checking A,B,C and whatever i select from A/B/C those corresponding values from other listboxes are displayed.

Hope so you understand...

Is it possible to do like that?

Thanks...