topic Re: Create a single list of values based on multiple columns in App Development

Create a single list of values based on multiple columns

jmalenfant — Thu, 18 Aug 2016 17:30:31 GMT

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

Re: Create a single list of values based on multiple columns

Gysbert_Wassenaar — Fri, 19 Aug 2016 06:06:06 GMT

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;

Re: Create a single list of values based on multiple columns

jmalenfant — Fri, 19 Aug 2016 14:43:33 GMT

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?

Re: Create a single list of values based on multiple columns

Gysbert_Wassenaar — Fri, 19 Aug 2016 15:18:17 GMT

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.