topic Expression in QlikView

Expression

VishalSingh18 — Wed, 25 Nov 2020 16:16:04 GMT

Hello all, I want to develop a expression that gives value explicit of days before the max date present in data e.g max(Date): 65.8 max(Date)-1: 53.8 max(Date)-2: 66.8 max(Date)-3: 65.6 max(Date)-4: 65.7 I have tried many expression and it returns Till Date value what I want is value recorded explicitly on that day Thanks and Regards Vishal Singh

Re: Expression

jochem_zw — Wed, 19 Feb 2020 18:55:13 GMT

See attached

Re: Expression

VishalSingh18 — Thu, 20 Feb 2020 09:01:21 GMT

I am not able to open the attachment 😞

Re: Expression

jochem_zw — Thu, 20 Feb 2020 09:24:48 GMT

what i did:

create a table with Date as dimension and this expression:

if(max(Total{1}Date)=Date,65.8
,if(max(Total{1}Date)-1=Date,53.8
,if(max(Total{1}Date)-2=Date,66.8
,if(max(Total{1}Date)-3=Date,65.6
,if(max(Total{1}Date)-4=Date,65.7)))))

Result