Hi all,
I am trying to find a solution to provide users with the ability to build up a table from a selection list box. In the past we have done this through using data islands for each custom table and mapping the data island tables with the conditional show hide. Upon researching data model efficiency I have come to the conclusion that data island are bad and cause slower dashboard speeds.
The first solution I discovered to this was using expressions in a list box to match to fields in the data model. For example, the list box would look like this:
=IF(MATCH($Field,'Field_A','Field_B','Field_C','Field_D'),$Field)
This works as I can make the conditional show / hide in the table columns as below:
=SubStringCount(concat($Field,'|'),'Field_A')
This gives me a solution that works, but means I have to show internal field names in the list box which is not appealing to an end user.
If found a great solution to this here: https://www.qlikviewaddict.com/2013/05/user-friendly-field-names-in-qlikview.html which uses a mapping table for old and new names.
However - doing this creates a data island. I can live with having just one island for the purposes of this. The new custom expression looks like this:
=IF(MATCH($Field,'Field_A','Field_B','Field_C','Field_D'),UserFriendlyFieldName)
Now if I want to apply this approach across multiple tables with different columns, I get one long list of fields in the list box (the list of UserFriendlyFieldName) rather than the values I enter into the custom expression.
Im struggling to close the loop on this final part. Does anyone have any advice / guidance on how to solve the initial requirement in a data model efficient way? I appreciate changing field names in the data model would be an option also but the client would prefer not to do this.
