Help Please Create Pivot Table with individual fields from load script
I have been working with survey data trying to get a proper pivot table. Due to the fact that the each answer is a separate field I am having trouble getting a pivot table to look the way I would like. Included an example of the pivot I am able to make below, I would like to have the dimension switched with the expression. I know you can drag it dynamically, but I would like to do differences between quarters in the table, which then is not possible. My thought was to somehow make a parent category to group the necessary questions, I have been struggling with this for a while and any help would be greatly appreciated. The code for the questions I want to group is below as well.
Re: Help Please Create Pivot Table with individual fields from load script
I added an excel book with an example of how the data is structured. Below is what I would like to eventually like to be able to build in the UI. I would like the different survey questions to be listed where the countries are in the below table.I
I am not sure if this complicates things but the data will be brought into Qlik through a API call in the future and formatting will be set up the same way as it appears in the excel book above. Thank you in advance for your help and expertise.