Qlik Sense variables that are arrays of values and running them through functions
Can we have arrays as variables and run them through functions? For instance, say I want to collect the values of the Date Created field of all records where Program = Swimming. Can I make an array, vSwimmingDateCreatedArray, of all those values and then run that array through a function that creates another array of the days between each date in vSwimmingDateCreatedArray? I want to do this with already loaded data in Qlik Sense, not Qlik View. If you could give me a couple examples with proper syntax and also point me to the right documentation, it will be much appreciated. Thanks
In general you could put (nested) arrays into variables but within the UI there is no native (maybe some extension provide such logic) loop-feature available. This means you would need to pick the right values from there with string-functions - and again it's in general possible but surely not easy.
I wouldn't recommend such an approach because it would be really hard work for advanced users and most likely there are other approaches much easier. If it should be really done in the UI you could use aggr-functions: QlikView-Technical-Brief-AGGR but better would be to do the essential work within the script.
