topic Re: Need Help on Straight Table filteration in QlikView

Need Help on Straight Table filteration

Thu, 23 Apr 2015 07:25:43 GMT

Need help in Straight table filter

I have a column called Report_Date which is having dates in it . I need to generated a straight table which will show me next 5 days Report_Date column data from today onwards . Say today date is 23rd April 2015 so it should show only those records starting from today to 28th April 2015 in straight table.

Re: Need Help on Straight Table filteration

maxgro — Thu, 23 Apr 2015 20:49:55 GMT

with this script

load

date(makedate(2015) +floor(rand()*365)) as reportdate,

rand()*10 as exp

AutoGenerate

1000;

use this expression

sum({$<reportdate={">=$(=Today())<=$(=date(num(Today())+5))"}>} exp)