topic Re: Change Dimension (Sort) in QlikView

Change Dimension (Sort)

pgalvezt — Mon, 25 Nov 2013 13:43:44 GMT

Hello,

How I can remove a value and put it in another location? If can change the name (Yellow to Green)

I have 7 dimensions: Group Cod. Account Account Cod Sub Account and so on

My expression is sum(Values).

The problem that I have in QlikView is cod Account (2000) appears in other side. I would like to take ar (2000) with the others 2000 and sum it.

Another thing My first sort is:

=Match(group,'Gerencia','Proveedores','Otros Ingresos de la Explotacion','Costos','Ventas').

And I did the second sort by Cod Account:

=Match(cod_count,'','1000','1100','1150','1300','1400','2000','2005','2100','2200','2210','2230','2300','2400','2500','2501','2550','2600','2700','2701','2800','2850','3000','3100','3110','3111','3202','3203','3204','3206','3210','3216','3219','3400','3402','3600','4005','4100','4111','4120','4200','4202','4203','4205','4206','4210','4220','4221','4300','4320','4400','4407','4408','4409','4410','4411','4420','4421','4425','5000','5002','5980','5990','6300','6308','6311','6312','6330','6331','6332', '6335','6350','6360','6361','6369').

I thought that doing this match QlikView could join the 2000 and sum it. I left an excel file for major comprehension

Thanks!

Re: Change Dimension (Sort)

Mon, 25 Nov 2013 14:36:58 GMT

Hello,

First of all I think you want to make a cross table.

Did you tried to move the column of cod.cc to the first column?

I enclosed an example.

Re: Change Dimension (Sort)

pgalvezt — Mon, 25 Nov 2013 14:43:18 GMT

Hello Julien,

Thank you for your reply. Explain me how did you do that?

Did you tried to move the column of cod.cc to the first column? No I didn´t Im going to do that.

Thanks!

Re: Change Dimension (Sort)

pgalvezt — Mon, 25 Nov 2013 14:51:47 GMT

It works but the view is displayed messy!

Is there another way keeping the original order?

Thanks!

Re: Change Dimension (Sort)

Mon, 25 Nov 2013 14:53:43 GMT

Go to the properties of the object and modify the order on selecting the good dimension.

Re: Change Dimension (Sort)

pgalvezt — Mon, 25 Nov 2013 15:13:33 GMT

When I try to change the dimension in the sort tab QlikView does not make me change.

Re: Change Dimension (Sort)

Mon, 25 Nov 2013 15:25:19 GMT

Could you ssend me your application in order to understand what you want,

Re: Change Dimension (Sort)

pgalvezt — Mon, 25 Nov 2013 15:44:02 GMT

The same Test0 that you sent me but I'd like that Dimension Group goes first.

Re: Change Dimension (Sort)

pgalvezt — Mon, 25 Nov 2013 17:25:00 GMT

It seems cant be work that way. In any case very thanks. Im going to find another way to sort the last step.