Create a single list of values based on multiple columns

[jmalenfant]

Hi - I'm sure this is a simple question, but I cannot find the answer anywhere.

Here is a very simple data model (based on excel sheets) in Qlik Sense. The use cases are below, but basically I want to create a filter pane "sources of data" that simply presents a unique list of values from the sources of data 1, sources of data2 and sources of data 3 columns. A user would search for organizations or datamarts that have a specific source of data 

[Gysbert_Wassenaar]

Then you need to put all the data from the three fields into one field. That's something you need to fix in the load script.

NewSheet1:

CrossTable(Field, Value)

LOAD * RESIDENT Sheet1;

[jmalenfant]

Thanks. Do you know if it's possible to do this without changing the load script? Could I somehow create a master item, new variable, or custom object to do this?

[Gysbert_Wassenaar]

I'm fairly sure it's not possible, but I could be wrong. What I do know that there is no excuse other than 'Look mum, see what totally cool, but utterly useless things I can do' to try it. This should be fixed in the script.