topic Dynamic dimension in a pivot table in QlikView

Dynamic dimension in a pivot table

Fri, 29 May 2009 18:53:47 GMT

Hi, i have another question.

I have to develop some pivot tables with the same columns, the difference is the dimension, in one is the product, other the category, other the trademark of the product.

Can i put in the document a dropdown field, for example, with the options for the dimension and in the pivot table, in the dimensions property, reference the value of the dropdown fields instead directly the name of the field to avoid create five or six pivot tables?

Thanks

Dynamic dimension in a pivot table

Anonymous — Fri, 29 May 2009 19:53:25 GMT

Hi vsanchez,

I would suggest using a group for the dimensions. Under Settings > Document Properties > Groups you can define a dimension group and add the fields you want to this group. Then add the group as dimension in your chart and you'll be able to cycle through the dimensions without having to change the expressions.

//JSN

Dynamic dimension in a pivot table

Fri, 29 May 2009 21:11:04 GMT

Thanks, Jsn.