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: 
markgraham123
Specialist
Specialist

display data in table only when specific dimension is selected

Hi,

I'm trying to create a table where when i select a value from dimension, one table should be visible.

In the attached Example, when i select a value from W1 list, only W1 table values should be visible.

similarly, when W2 list is selected, only W2 table values should be visible even though there is interlink.

Help pls.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

GetSelectedCount(W2) count the selected so if you don't select W2, W2 table doesn't show

View solution in original post

9 Replies
sunny_talwar

Trying to understand better here -> Both the tables should not be visible until you make a selection in W1 or W2?? As soon as you select one of the other, one of them should become visible?

maxgro
MVP
MVP

I think

you can use the GetSelectedCount or GetPossibleCount functions in layout tab of the chart (show conditional)

markgraham123
Specialist
Specialist
Author

Hi Sunny,

If i select one i.e.W1. only W1 table should show data...

W2 table should still be there with no data.

markgraham123
Specialist
Specialist
Author

Hi Massimo,

I tried but as there are common fields W1, W2 are same.

Its pulling data in second table too.

maxgro
MVP
MVP

GetSelectedCount(W2) count the selected so if you don't select W2, W2 table doesn't show

markgraham123
Specialist
Specialist
Author

Thanq massimo.

i used set analysis which is working too, but Get selectedcount() showing good performance.

Thanks again.

markgraham123
Specialist
Specialist
Author

Hi Massimo,

I have a question here...

Its working but, when i select W1, W2 gets cleared and When i select W2, W1 gets cleared.

Can't i make them individual, where i can select W1 and W2 at once with its values populated in its own tables???

maxgro
MVP
MVP

when you select W1 listbox (and don't select in W2 listbox) you want

show W1 table

don't show W2 table

or

show W1

show W2

?

markgraham123
Specialist
Specialist
Author

Massimo,

If i select 'A' in W1....

It should show the associated values in W1 table.

along with the corresponding values of 'A' in w2.

I have uses Pick(Match(...)

But not working.