Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
jumiprado
Creator
Creator

Error Calcular Grafico Barras

Amigos!

tengo el siguiente problema, tengo la EXPRESION que voy a colocar más abajo para poder calcular los diferentes valores en los que cambia por MES-AÑO (Ene-2013, Feb-2013, etc) una cantidad. El problema es que me da un valor estatico (el último que suma), podrían ayudarme?

GRACIAS

EXPRESION:

count({<SECCION={7}, Estado={'A'}, [Filtro Fecha de Ingreso]={'OK'},MES_ID_INGRESO = {"<=$(vMaxMonthSel)"}>}[Seccion-Poliza-Grupo])

+

count({<SECCION={7},ESTADO={'B','M'}, [Filtro Fecha de Ingreso]={'OK'} ,[Filtro Fecha de Baja]={'OK'}, MES_ID_BAJA = {">$(vMaxMonthSel)"},MES_ID_INGRESO = {"<=$(vMaxMonthSel)"} >}[Seccion-Poliza-Grupo])

+

count({<SECCION={7},Estado={'R'}, [Filtro Fecha de Ingreso]={'OK'},MES_ID_REHABILITACION= {"<=$(vMaxMonthSel)"}, MES_ID_INGRESO= {"<=$(vMaxMonthSel)"}>}[Seccion-Poliza-Grupo])

DIMENSION

MonthYear (Viene del MasterCalendar)

ErrorMode=0
QuartersMap: 
MAPPING LOAD  
rowno() as Month
'Q' &
Ceil (rowno()/3) as Quarter 
AUTOGENERATE (12); 
 
Temp: 
Load
              
//min("Fecha de Alta") as minDate, 
               41275 as minDate,
              
max("Fecha de Alta") as maxDate 
Resident BASE_GMD; 
 
Let varMinDate = Num(Peek('minDate', 0, 'Temp')); 
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp')); 
DROP Table Temp; 
 
TempCalendar: 
LOAD 
              
$(varMinDate) + Iterno()-1 As Num
              
Date($(varMinDate) + IterNo() - 1) asTempDate 
              
AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate)
 
MasterCalendar: 
Load 
              
TempDate AS Date
              
//week(TempDate) As Week, 
               Year(TempDate) As Year
              
Month(TempDate) As Month
              
Day(TempDate) As Day
              
//YeartoDate(TempDate)*-1 as CurYTDFlag, 
               //YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
               //inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12, 
               date(monthstart(TempDate), 'MMM-YYYY') asMonthYear
              
//ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter, 
               //Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear, 
               //WeekDay(TempDate) as WeekDay,
               (Year(TempDate)-1)*12 + Month(TempDate) asMES_ID
                
Resident TempCalendar 
Order By TempDate ASC
Drop Table TempCalendar;


SET vMaxMonth = =max({1}MES_ID);
SET vPriorMonth = =max({1}MES_ID)-1;

SET vMaxMonthSel = =max(MES_ID);
SET vPriorMonthSel = =max(MES_ID)-1;


Gráfico que Obtengo


image001.jpg

SALUDOS Y MUCHAS GRACIAS!

Labels (1)
0 Replies