Dynamic Pivot table

Sun, 31 Aug 2014 12:26:09 GMT

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?

Re: Dynamic Pivot table

northerner — Sun, 31 Aug 2014 12:57:00 GMT

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!

Re: Dynamic Pivot table

ashfaq_haseeb — Sun, 31 Aug 2014 12:57:49 GMT

Hi,

Yes it possible.

have a look at the below application.

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

Regards

ASHFAQ

topic Re: Dynamic Pivot table in QlikView

Dynamic Pivot table

Re: Dynamic Pivot table

Re: Dynamic Pivot table