Dimension Difference

qlikviewaf — Wed, 03 Feb 2021 15:35:34 GMT

Hi,

i created 2 calculated dimension as follow:

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!

Re: Dimension Difference

QFabian — Wed, 03 Feb 2021 17:34:19 GMT

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)

topic Re: Dimension Difference in QlikView

Dimension Difference

Re: Dimension Difference