Remove the Raw from Staright Table

sona_sa — Thu, 25 Jun 2015 03:34:02 GMT

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.

Re: Remove the Raw from Staright Table

PrashantSangle — Thu, 25 Jun 2015 03:48:34 GMT

Hi,

In your 1st expression write

if(column(2)>0,yourExpression)

Regards,

PrashantSangle — Thu, 25 Jun 2015 03:49:30 GMT

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

)