Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

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
sunny_talwar

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
sunny_talwar

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
Specialist
Specialist
Author

Brilliant, as usual!

Thanks for this tremendous tip!

dafnis14
Specialist
Specialist
Author

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

sunny_talwar

I think what I really wanted to do was this

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


But what you did also worked...

dafnis14
Specialist
Specialist
Author

Sometimes miracles happen..