Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

View solution in original post

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

View solution in original post

dafnis14
Contributor III

Re: Dynamic report & container for dims

Brilliant, as usual!

Thanks for this tremendous tip!

Highlighted
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..