Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
dafnis14
Contributor III

Dynamic report & container for dims

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:

Dynamic_dims.png

Attached is a sample mode.

Will appreciate some tips here..

Thanks!

1 Solution

Accepted Solutions

Re: Dynamic report & container for dims

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

5 Replies

Re: Dynamic report & container for dims

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

dafnis14
Contributor III

Re: Dynamic report & container for dims

Brilliant, as usual!

Thanks for this tremendous tip!

dafnis14
Contributor III

Re: Dynamic report & container for dims

Hi Sunny,

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

Dynamic_dims_001.png !

I changed the expression slightly:

from

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

to:

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

and now it does..

Dynamic_dims_002.png

Re: Dynamic report & container for dims

I think what I really wanted to do was this

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


But what you did also worked...

dafnis14
Contributor III

Re: Dynamic report & container for dims

Sometimes miracles happen..