Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
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!
It works but the view is displayed messy!
Is there another way keeping the original order?
Thanks!
Go to the properties of the object and modify the order on selecting the good dimension.
When I try to change the dimension in the sort tab QlikView does not make me change.
Could you ssend me your application in order to understand what you want,
The same Test0 that you sent me but I'd like that Dimension Group goes first.
It seems cant be work that way. In any case very thanks. Im going to find another way to sort the last step.