create self service pivot qlik cloud

[bartwelvaarts]

hi all,

i want to create a self service pivot in qlik cloud. i want a drop down listbox with multiple dimensions that users can select, and that the dimension will be added to the pivot (can be multiple). and same for measures. anyone any idea how to this or has an example?

thanks in advance!

[PrashantSangle]

check for how to develop adhoc reports in Qlik.

Let me do some search for you.....

Regards,

Prashant Sangle

[MatheusC · Accepted solution]

Yes, ad hoc is a good solution. @PrashantSangle , if you allow it, this Git file with the files and details about the creation might be useful.

https://github.com/tensini/adhoc_tensini/tree/main?tab=readme-ov-file


- Regards, Matheus

[bartwelvaarts]

many thanks it works great! im using this for the metric $(=SubField(Concat(DISTINCT Metric, '|'), '|', 1)) and SubField(GetFieldSelections(Label), ',', 1) for the label, based on a excel sheet. only problem for the label is, when i add the second measure, the 'label 1' is now seen as 'label 2'. anyone any idea's how to tackle this?