topic Dynamic report & container for dims in QlikView

Dynamic report & container for dims

dafnis14 — Mon, 28 May 2018 11:53:17 GMT

Hi,

I have to design a dynamic report with many dimensions & metrics.

So i decided to use a container to split the dimensions list boxes.

But when I select a dim value from one list, the dim fields from the other list box are displayed,

regardless of the condition:

Attached is a sample mode.

Will appreciate some tips here..

Thanks!

Re: Dynamic report & container for dims

sunny_talwar — Mon, 28 May 2018 13:03:09 GMT

Check with GetFieldSelections instead of Concat... because Concat will still have the field names when nothing is selected whereas GetFieldSelections will only show when a value is selected in _Dim1 or _Dim2

=SubStringCount('|' & GetFieldSelections(_Dim1, '|,') & '|', '|Code|') = 1

Re: Dynamic report & container for dims

dafnis14 — Mon, 28 May 2018 13:16:49 GMT

Brilliant, as usual!

Thanks for this tremendous tip!

Re: Dynamic report & container for dims

dafnis14 — Tue, 29 May 2018 14:28:04 GMT

Hi Sunny,

When 2 values are selected, still only one is displayed.

I changed the expression slightly:

from

=SubStringCount('|' & GetFieldSelections(_Dim1, '|,') & '|', '|Code|') = 1

to:

=SubStringCount('|' & GetFieldSelections(_Dim1,'|') & '|', '|Code|') =1

and now it does..

Re: Dynamic report & container for dims

sunny_talwar — Tue, 29 May 2018 14:36:13 GMT

I think what I really wanted to do was this

=SubStringCount('|' & GetFieldSelections(_Dim1, '|,|') & '|', '|Code|') = 1

But what you did also worked...

Re: Dynamic report & container for dims

dafnis14 — Tue, 29 May 2018 15:18:06 GMT

Sometimes miracles happen..