Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
I have a straight table, Now I want to remove the raws, where Expirary Date is Blank.
Please find the attached qvw.
Thanks.
Your 1st expression like below
if(Column(2)>0,
If(Name='Vietnam',Min({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy')) <=$(=date(max(CDate),'dd-MMM-yy'))"}>}
aggr(if(max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy'))"}>}CDate)<=
max({<CDay=,CMonth=,CYear=>}LicenseDeployDate),Min({1}MaxNoOfLicense),Min({1}MinNoOfLicense)),NavisionInstance,CDate)),
Max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy')) <=$(=date(max(CDate),'dd-MMM-yy'))"}>}
aggr(if(max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy'))"}>}CDate)<=
max({<CDay=,CMonth=,CYear=>}LicenseDeployDate),max({1}MinNoOfLicense),max({1}MaxNoOfLicense)),NavisionInstance,CDate)))
)
Hi,
In your 1st expression write
if(column(2)>0,yourExpression)
Regards,
Your 1st expression like below
if(Column(2)>0,
If(Name='Vietnam',Min({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy')) <=$(=date(max(CDate),'dd-MMM-yy'))"}>}
aggr(if(max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy'))"}>}CDate)<=
max({<CDay=,CMonth=,CYear=>}LicenseDeployDate),Min({1}MaxNoOfLicense),Min({1}MinNoOfLicense)),NavisionInstance,CDate)),
Max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy')) <=$(=date(max(CDate),'dd-MMM-yy'))"}>}
aggr(if(max({<CDay=,CMonth=,CYear=,CDate={">=$(=date(max(CDate)-14,'dd-MMM-yy'))"}>}CDate)<=
max({<CDay=,CMonth=,CYear=>}LicenseDeployDate),max({1}MinNoOfLicense),max({1}MaxNoOfLicense)),NavisionInstance,CDate)))
)