topic Re: display data in table only when specific dimension is selected in QlikView

display data in table only when specific dimension is selected

markgraham123 — Mon, 27 Jul 2015 20:04:13 GMT

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.

Re: display data in table only when specific dimension is selected

sunny_talwar — Mon, 27 Jul 2015 20:08:16 GMT

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?

Re: display data in table only when specific dimension is selected

maxgro — Mon, 27 Jul 2015 20:15:10 GMT

I think

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

Re: display data in table only when specific dimension is selected

markgraham123 — Mon, 27 Jul 2015 20:18:35 GMT

Hi Sunny,

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

W2 table should still be there with no data.

Re: display data in table only when specific dimension is selected

markgraham123 — Mon, 27 Jul 2015 20:19:20 GMT

Hi Massimo,

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

Its pulling data in second table too.

Re: display data in table only when specific dimension is selected

maxgro — Mon, 27 Jul 2015 20:25:38 GMT

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

Re: display data in table only when specific dimension is selected

markgraham123 — Mon, 27 Jul 2015 20:31:25 GMT

Thanq massimo.

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

Thanks again.

Re: display data in table only when specific dimension is selected

markgraham123 — Mon, 27 Jul 2015 20:40:04 GMT

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???

Re: display data in table only when specific dimension is selected

maxgro — Mon, 27 Jul 2015 20:47:49 GMT

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

show W1 table

don't show W2 table

show W1

show W2

Re: display data in table only when specific dimension is selected

markgraham123 — Mon, 27 Jul 2015 20:52:40 GMT

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.