Dimension Difference

[qlikviewaf]

Hi,

i created 2 calculated dimension as follow:

1) 

round(aggr(Sum({<Year=, Quarter=, Week=,Day=,Invoice_Date_Num=,Item_Category={$(vNoInstruments)}, SurgeryDateNum=,SurgeryMonthYear=,Month_Surgery=,Year_Surgery=,Day_Surgery=>}
WI_EUR),ShipTo)
/aggr(Sum({<Year=, Quarter=, Week=,Day=,Invoice_Date_Num=,Item_Category={$(vNoInstruments)}, SurgeryDateNum={">=$(=Num(Today()-365))"}>}
ExtendedOriginal)
+Sum({<Year=, Quarter=, Week=,Day=,Invoice_Date_Num=,Item_Category={$(vNoInstruments)}, SurgeryDateNum={">=$(=Num(Today()-365))"}>}
WI_EUR),ShipTo)*365)

2) =Today()-SurgeryDateNum

i would like to have another column, just as difference of the 2 calculated dimension, but i'm not able to do it.

I'm using a straight table. How i can do this? 

Any help is really appreciated, thanks!

[QFabian]

Hi @qlikviewaf , please try creating that columns as expressions, and not as Dimensions.

Then, you can create a third expression with : column(1)-column(2)