topic Need Help?? in QlikView

Need Help??

paulwalker — Tue, 20 Jan 2015 03:48:26 GMT

Hi Community,

I am using this expression comparing with Date and Today().

LOAD *, IF(NETWORKDAYS([Date],TODAY())-1=0,'Day 0',

IF(NETWORKDAYS([Date],TODAY())-1=1,'Day 1',

IF(NETWORKDAYS([Date],TODAY())-1=2,'Day 2',

IF(NETWORKDAYS([Date],TODAY())-1=3,'Day 3',

IF(NETWORKDAYS([Date],TODAY())-1=4,'Day 4',

IF(NETWORKDAYS([Date],TODAY())-1=5,'Day 5','Days >5')))))) as Aging

Here i am comparing with Today() date, but i want change based on date selection..

Earlier i have proper data up to Today's date... but present i don't have 2015 data..(Direct it goes to else part)

How to write Expression???

senpradip007 — Tue, 20 Jan 2015 04:51:01 GMT

Could you upload sample qvw?

its_anandrjs — Tue, 20 Jan 2015 05:52:22 GMT

Hi,

Try with this expression

LOAD *, IF(NETWORKDAYS([Date],Max([Date]) )-1=0,'Day 0',

IF(NETWORKDAYS([Date],Max([Date]))-1=1,'Day 1',

IF(NETWORKDAYS([Date],Max([Date]))-1=2,'Day 2',

IF(NETWORKDAYS([Date],Max([Date]))-1=3,'Day 3',

IF(NETWORKDAYS([Date],Max([Date]))-1=4,'Day 4',

IF(NETWORKDAYS([Date],Max([Date]))-1=5,'Day 5','Days >5')))))) as Aging

Regards,

Anand