Discussion board where members can get started with QlikView.
I would like to have a table with the date as dimension and in one of the expressions that I have, I would like to get the value of the previous year.
The thing is that I want to achive this set analysis without using above or other functions that could change in case of changing the order of the table.
Based on the following data sample I would like to have in a table the 20181231 as a dimension and the 972 value:
Test:LOAD * INLINE [Fecha, Value20180101, 489720181231, 128920170101, 789220170608, 364820171231, 972];
NoConcatenateTest2:LOADyear(date(Date#(Fecha,'YYYYMMDD'),'DD/MM/YYYY')) as Year,date(Date#(Fecha,'YYYYMMDD'),'DD/MM/YYYY') as FECHA,Valueresident Test;
drop table Test;
As I have many expressions, having a calculated dimension as follows is not a solution:
Dimension: Aggr(NODISTINCT addyears(Max(YearEnd(FECHA)),1),Year)
Expression: Sum(if(FECHA = Aggr(NODISTINCT Max(FECHA),Year),Value))