topic Dynamic position of dimensions in QlikView

Dynamic position of dimensions

djallelsadki — Fri, 28 Nov 2014 13:52:30 GMT

Hi,

i'm creating a new dynamic report with a pivot chart,

I want the dimensions that have the user selects a position in the order of the selection he made

if the user selects the dimension 1 then 2 then 3

the pivot chart will be made as follows:

dim1 dim3 dim2

possible? any ideas?

thank you

alexandros17 — Fri, 28 Nov 2014 13:55:28 GMT

I have not undertood your requirement, brobably you need cyclic or drill down groups of dimensions, define them in the dimension tab

datanibbler — Fri, 28 Nov 2014 13:58:08 GMT

Hi Djallel,

depending on the nr. of possible combinations the user might select, the following might be an option (if there's not too many possible variations)

=> Create n objects, all in the exact same position, with visibility_conditions to match each possible selection.

In general, it's possible to use variables in charts - it should also be possible to use variables as dimensions?

HTH

Best regards,

DataNibbler

marcus_sommer — Fri, 28 Nov 2014 15:01:51 GMT

It's not a finish solution more an approach how could it be done and it's in german but you could it translate, maybe google translator:

But it's only nice to have I wouldn't try it.

- Marcus