Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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?
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.