Extracting daily details

[#1]

Hi

i have a problem in extracting the details according to the present day.

Ex:

Name	Status	INC	date
jon	closed	a111	12-05-14
jon	closed	a112	13-05-14
shalani	closed	a118	14-05-14
shalani	closed	a119	18-05-14
shalani	closed	a113	20-05-14
shalani	closed	a114	20-05-14
dasun	closed	a115	20-05-14
dasun	closed	a116	20-05-14
dasun	Pending	a120	20-05-14
dasun	Pending	a121	20-05-14

the above shows a similar example that i am trying to work on. i need to generate a chart from daily details. i know how to create the chart but i can not extract the details according to the present day. i need to extract the data as shown below for today (the daily details)

shalani	closed	a113	20-05-14
shalani	closed	a114	20-05-14
dasun	closed	a115	20-05-14
dasun	closed	a116	20-05-14
dasun	Pending	a120	20-05-14
dasun	Pending	a121	20-05-14

.. plz can some one help me with this issue..

thank you in advance

[SergeyMak]

Hi

Try this

Only({$<date={$(=today())}>}INC)

I will upload an example later

[SergeyMak]

Small changes

I changed Date format for date using Date# and Date,

Than Only({$<date={"$(=today())"}>}INC)

and hide the unimportant column on the presentation tab

PFA

[#4]

since i am using a personal edition Qlikview is not allowing me to open your example will there be any possibility of attaching a screen shot plz

[SergeyMak]

Load script is:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='D/MM/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LOAD Name,

    Status,

    INC,

   Date(Date#(date,'DD-MM-YYYY'),'DD/MM/YYYY') AS date

FROM

[http://community.qlik.com/thread/118986]

(html, codepage is 1252, embedded labels, table is @1);

The result is:

[#6]

this is not working 4 me

[ashwanin]

Can you post your sample qvw.

[#8]

i dnt know whether you will be able to open this cz i am using a personal edition

and i want to generate the chart only 4 the present day.

[#9 · Accepted solution]

write the below condition in expression tab:

if(date()>=today(),INC)