Dynamic Dimensions

Anonymous — Thu, 25 Jun 2015 16:04:57 GMT

Hello,

I am looking for some help.

In one of our reports, we wanted to give users the option of choosing the combination of dimensions they wanted to choose. I am trying achieve below features in my report. Lets say I have ten Dimensions Dimension1,Dimension2,Dimension3....and two expressions sum(sales),sum(taxes)

1) I wanted to provide the list of dimensions available for the user to choose .

2) I wanted build a straight chart where users will be looking into the dimensions they selected above and sum(sales),sum(taxes)

3) If users choose only Dimension1 they should only see Dimension1,sum(sales),sum(taxes) in the straight chart and if they select dimension2 in combination to Dimension1 they should see Dimension1,Dimension2,sum(sales),sum(taxes) and so on.

I tried using the $Field in a list box, and then used the same as Dimension in my straight chart, but I cannot limit the Dimensions here.

Any help would be highly appreciated.

Thanks

Heera

Re: Dynamic Dimensions

swuehl — Thu, 25 Jun 2015 16:08:38 GMT

Starting with QV11, you can use conditional dimensions and expressions to do what you want.

There is a demo on how to do this in the 'What's new in QV11' sample application.

Re: Dynamic Dimensions

ramoncova06 — Thu, 25 Jun 2015 16:48:31 GMT

Customizable Straight Table

here is a how to

Re: Dynamic Dimensions

Anonymous — Sun, 28 Jun 2015 23:46:59 GMT

Thanks a ton. It helped me in solving my problem.

Thanks

topic Dynamic Dimensions in QlikView

Dynamic Dimensions

Re: Dynamic Dimensions

Re: Dynamic Dimensions

Re: Dynamic Dimensions