Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
VishalSingh18
Contributor III
Contributor III

Expression

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
1 Solution

Accepted Solutions
jochem_zw
Partner
Partner

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)))))

 

ResultResult

 

View solution in original post

3 Replies
jochem_zw
Partner
Partner

See attached

VishalSingh18
Contributor III
Contributor III
Author

I am not able to open the attachment 😞

jochem_zw
Partner
Partner

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)))))

 

ResultResult