Dynamic Pivot table

[#1]

hi dears

i want to let user be able to select different measures according different dimensions as they are using pivot table. i mean i want to let him to choose some of them(measures/dimensions) when he is using pivot table to make his preferred report. is it possible? if yes, how?

[northerner · Accepted solution]

Hi,

You can change dynamically change the dimension shown in a chart field by using a calculated dimension and a variable.

As a small example - imagine you have a table with three columns, A and B are dimensions and x is a measure.

A  B  x

----------

A1 B1 23

A1 B2 14

A2 B2 76

Create a variable (for this example we'll call it vDim).  Create an input box that populates this variable using pre-defined values.  The pre-defined values will be the names of the dimensions (e.g. A and B).  This allows the user to choose a dimension.

Next, create a calculated dimension in the chart that uses the variable and dollar expansion to give the name of the selected value.  The dimension definition would be something like: [$(vDim)]

Now, if the user selects A from the input box, they should see values of column A in the calculated dimension. If they change the value in the input box to B, they should see values from column B

A similar approach can be used for dynamic measures.

Hope this helps!

[ashfaq_haseeb]

Hi,

Yes it possible.

have a look at the below application.

http://community.qlik.com/docs/DOC-5404

Regards

ASHFAQ