topic Re: Create user defined grouping in pivot table in QlikView

Create user defined grouping in pivot table

Thu, 29 Sep 2016 17:26:45 GMT

How can I provide flexibility to the users to do grouping in a pivot table. In the attached qvw file, I have drive capacity on columns which has been grouped in the script earlier. However, I want to provide the flexibility for the users to do their own grouping. Is this possible?

Re: Create user defined grouping in pivot table

maxgro — Thu, 29 Sep 2016 19:28:39 GMT

try to read this

Users can map/group dimensions at run-time!

Re: Create user defined grouping in pivot table

MarcoWedel — Thu, 29 Sep 2016 21:38:52 GMT

maybe also helpful:

grouping dimension values

regards

Marco

Re: Create user defined grouping in pivot table

Mon, 03 Oct 2016 06:23:23 GMT

Hi Marco,

Thank you so much. I think that's exactly what I wanted. However, as I'm new to Qlikview I'm not able to work with the macro provided. In the QVW file that I had attached initially I wanted the users to have this dynamic grouping to be done based on the 'Drive Capacity' in the pivot table. Is there a easier way to do this. thank you!