topic Re: Conditional display Table in QlikView

Conditional display Table

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have created Pivot table converted to cross table with 2 dim and 2 measures and created Table Box with some attributes.

from this i am trying to display the Table box conditionally based on selection of Cell from Pivot table.

i have used getfieldselections function in Table box layout tab(Show Always or Conditional) but not working as expected.

Can any one suggest the solution.

Thanks

Rajesh.

Re: Conditional display Table

tresB — Fri, 20 Jul 2018 05:21:25 GMT

What exact expression have you tried?

Re: Conditional display Table

Rajesh — Fri, 20 Jul 2018 05:27:27 GMT

Hi Tresesco,

=If(Len(GetFieldSelections(short_description))>0, 1, 0) used expression in Layout tab in Table Box

Re: Conditional display Table

tresB — Fri, 20 Jul 2018 05:32:52 GMT

That should work. Or, a simpler expression =GetSelectedCount(short_description) could work. Could share your sample qvw?

Re: Conditional display Table

bhaskar_sm — Fri, 20 Jul 2018 05:37:45 GMT

can you provide sample app??

Re: Conditional display Table

Rajesh — Fri, 20 Jul 2018 05:59:06 GMT

HI Tresesco,

i have created Calendar view with using Pivot chart need to select on Cell of the Chart and it should display the respected cell data in Table box and it should hide the Pivot Chart.

i tried using Week field its working but i need to select the cell of the Pivot.

Thanks

Rajesh

Re: Conditional display Table

tresB — Fri, 20 Jul 2018 06:04:42 GMT

If you select a field value from a chart, your conditional display might work, however, if you are selecting a cell that is coming from expression , it might not work that way.

Re: Conditional display Table

Rajesh — Fri, 20 Jul 2018 06:08:39 GMT

so how can we achieve the required functionality.

is there any other workaround.

can you suggest

Re: Conditional display Table

tresB — Fri, 20 Jul 2018 06:25:55 GMT

When you are clicking on a specific cell, see which fields values corresponding to it are getting selected. You might try using the same field(s) in the layout expression.