topic Re: Doubt with ciclic dimension in QlikView

Doubt with ciclic dimension

Mon, 02 Mar 2015 13:15:13 GMT

How if for example i have 6 dimensions in a ciclic dimmension

D1,D2,D3,D4,D5,D5

Is it possible to have the selected dimmension + the previous dimmension ?

for example if i'm in dimmension 5 in the table i'd see

Dimmension 4 // Dimension 5

etc..

Thank you,

greetings

Re: Doubt with ciclic dimension

sunny_talwar — Mon, 02 Mar 2015 13:23:24 GMT

As per my knowledge there is no way to have a single group display two fields at one time. If you don't mind me asking, why is this required? May be there is another way to achieve what your final goal might be.

Best,

Re: Doubt with ciclic dimension

maxgro — Mon, 02 Mar 2015 13:25:53 GMT

single field or two fields?

Re: Doubt with ciclic dimension

Mon, 02 Mar 2015 13:27:23 GMT

Sory i didn't understand what you mean with that. My english isn't good

Re: Doubt with ciclic dimension

Mon, 02 Mar 2015 13:28:18 GMT

I have to put two small graphics in the right and the table in the left and in the pivot table i have a lot of dimensions.

If i use the normal pivot table i dont have place to the graphics

Re: Doubt with ciclic dimension

Anonymous — Mon, 02 Mar 2015 13:29:40 GMT

Jeremias,

As fisrt dimension select your group. Add a calculated second dimension:

=if(GetCurrentField('YourGroup')='D6', D5, if(GetCurrentField('YourGroup')='D5', D4, .......

Marc.

Re: Doubt with ciclic dimension

maxgro — Mon, 02 Mar 2015 13:31:23 GMT

when you select dimension 5

do you want two fields, dimension4 dimension5

or do you only want one field dimension5 with the values of dimension 4 e 5?

Re: Doubt with ciclic dimension

sunny_talwar — Mon, 02 Mar 2015 13:31:26 GMT

Did not think about this. Kudos marcarreras

Best,

Re: Doubt with ciclic dimension

Mon, 02 Mar 2015 13:34:11 GMT

Ah ok when i select dimension 5 i wanna two fields

Dimmension 4 / Dimension 5 / expressions

Re: Doubt with ciclic dimension

maxgro — Mon, 02 Mar 2015 13:36:38 GMT

marc has already answered

Re: Doubt with ciclic dimension

Mon, 02 Mar 2015 13:53:33 GMT

Sory i realized that is a jerarquic expression not ciclic. Is it the same ?

Re: Doubt with ciclic dimension

Anonymous — Mon, 02 Mar 2015 13:57:07 GMT

exactly the same.

Re: Doubt with ciclic dimension

Mon, 02 Mar 2015 14:04:49 GMT

It doesn't work! I'll atach an example in the original message, because i couldn't atach it here

Re: Doubt with ciclic dimension

Mon, 02 Mar 2015 14:10:26 GMT

It is here!

Re: Doubt with ciclic dimension

Mon, 02 Mar 2015 14:17:28 GMT

Thank you

Do you know why it doesn't work ?

Re: Doubt with ciclic dimension

Anonymous — Mon, 02 Mar 2015 14:18:09 GMT

Jeremias,

My fault. Do not use comas inside GetCurrentField funtion:

=if(GetCurrentField(YourGroup)='D6', D5, if(GetCurrentField(YourGroup)='D5', D4, .......

Marc.

[Edit] Please Find Attached

Re: Doubt with ciclic dimension

sunny_talwar — Mon, 02 Mar 2015 14:20:55 GMT

You don't need to use single quotes within the GetCurrentField. Try this:

=if(GetCurrentField(J)='DIM4', DIM3,

if(GetCurrentField(J)='DIM3', DIM2,

if(GetCurrentField(J)='DIM2', DIM1)))

Best,