topic Subclassifications in QlikView

Subclassifications

gr_eldred — Mon, 28 Aug 2017 16:27:10 GMT

Good morning I have a problem with a set analysis I need to get the same subclassifications that are in the table on the left.

The first table is the sales calculation so far this quarter.

The second table is the inventory calculation, it is normal to have different subclassifications. I just need to show the same subclassifications in the second table. I tried with an if that is as follows:

if(

sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Especial Numerico], %Tipo_Dato = {'Inventario'} ,[Año Apple], [Mes Apple], [SemanaAppleEspecial], Almacen_Tipo_M = {'Facturación'} >}Existencia)+ //IOH

sum({< Ship_Status = {'In-Transit', 'Uplift','Shipment Picked Up' }, OC_Status_Articulo -= {'R'} >}Ship_Enviado)+ //OCIT

Num(sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Apple],[Año Apple], [Mes Apple], [SemanaAppleEspecial], %Tipo_Dato = {'Traspaso'}, Tra_Status={'Pendiente'} >}Tra_Faltante) )+ //Traspaso

(sum(Total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} , [Año Apple], [Mes Apple], [SemanaAppleEspecial], Mes, semana, Trimestre >}OR_Cantidad_recibida) - sum(total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} , [Año Apple], [Mes Apple], [SemanaAppleEspecial], Mes, semana, [Trimestre Especial Numerico], com_num_folio ={'*'}-{''} >}OR_Cantidad_recibida))//IPE

>0,

num(sum({$<Status-={'C'}, Clasificación -={'Servicios','Refacciones','Pagos*','*Core value*'}, [Año Apple]={$(V_Año_Actual)} ,[Trimestre Especial Numerico]={$(v_MaxTrimestreActual)}, SemanaAppleEspecial= {"<=$(v_MaxSemanaEsp)"}>} Cantidad_I)),

)

What is in bold is equivalent to the IOHT column of the second table.

I need the table rankings on the right to have the table on the left

Re: Subclassifications

rubenmarin — Mon, 28 Aug 2017 17:39:02 GMT

Hi Eldred, seems related to those groups that doesn't have data, have you unchecked the option to 'Supress zero values' in the presentation tab of the second table?

Also, what's the difference between the 'true' and 'false' part of the 'If'?

Re: Subclassifications

gr_eldred — Mon, 28 Aug 2017 17:47:44 GMT

Hola Ruben no hay diferencia entre el si y el no, si esta desmarcada la opcion de suprimir valores en cero solo que aun me sigue apareciendo mas de un lado las clasificaciones.

Lado izquierdo es ventas, lado derecho es inventario necesario mostrar la misma cantidad de subclasificaciones que se ven en la tabla derecha

Re: Subclassifications

gr_eldred — Mon, 28 Aug 2017 17:47:58 GMT

Hi Ruben there is no difference between the yes and the no, if it is clear the option to delete values in zero only that I still continue to appear more than one side the classifications.

Left side is sales, right side is inventory I need to show the same amount of subclasses that are seen in the right table

Re: Subclassifications

gr_eldred — Mon, 28 Aug 2017 17:51:43 GMT

For example, it should not appear in table 1 because I do not have it in the second table of inventories and also had no sales.

The other in the table on the left I am using the dimension of weeks and in the other I bring all unfiltered weeks

Re: Subclassifications

rubenmarin — Mon, 28 Aug 2017 17:54:24 GMT

So the left table is the one that has to be changed?

In this case it can be done cheking that 'Zupress zero values' in the left table.

Or maybe with a dynamic dimension like:

aggr(

if(

sum({< Ship_Status = {'In-Transit', 'Uplift','Shipment Picked Up' }, OC_Status_Articulo -= {'R'} >}Ship_Enviado)+ //OCIT

Num(sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Apple],[Año Apple], [Mes Apple], [SemanaAppleEspecial], %Tipo_Dato = {'Traspaso'}, Tra_Status={'Pendiente'} >}Tra_Faltante) )+ //Traspaso

>0, Subclassification, Subclassification)

Re: Subclassifications

gr_eldred — Mon, 28 Aug 2017 17:58:56 GMT

Try this one but I still have no success.

if(

or sum({< Ship_Status = {'In-Transit', 'Uplift','Shipment Picked Up' }, OC_Status_Articulo -= {'R'} >}Ship_Enviado)>0 //OCIT

or Num(sum({$<Fecha = { "=date(Max({1}Fecha))"},[Trimestre Apple],[Año Apple], [Mes Apple], [SemanaAppleEspecial], %Tipo_Dato = {'Traspaso'}, Tra_Status={'Pendiente'} >}Tra_Faltante) )>0 //Traspaso

or (sum(Total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} , [Año Apple], [Mes Apple], [SemanaAppleEspecial], [Trimestre Especial Numerico] >}OR_Cantidad_recibida) - sum(total{<%Tipo_Dato = {'Ordn_Comp'}, OR_rec_stat -= {'C'} , [Año Apple], [Mes Apple], [SemanaAppleEspecial], [Trimestre Especial Numerico], com_num_folio ={'*'}-{''} >}OR_Cantidad_recibida))>0//IPE

)

Appear more weeks and the CTO subclassification that should not appear (have a more subclassification of the left side)

Re: Subclassifications

gr_eldred — Mon, 28 Aug 2017 18:09:46 GMT

If I remove the zeros it will eliminate what did not have sales but if it has inventory

Re: Subclassifications

rubenmarin — Tue, 29 Aug 2017 10:01:55 GMT

And using the dynamic dimension?