topic Re: Re: Extracting daily details in QlikView

Extracting daily details

Tue, 20 May 2014 04:06:58 GMT

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

Re: Extracting daily details

SergeyMak — Tue, 20 May 2014 04:16:56 GMT

Try this

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

I will upload an example later

Re: Re: Extracting daily details

SergeyMak — Tue, 20 May 2014 04:25:13 GMT

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

Re: Re: Extracting daily details

Tue, 20 May 2014 04:37:58 GMT

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

Re: Re: Re: Extracting daily details

SergeyMak — Tue, 20 May 2014 04:40:54 GMT

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:

Re: Re: Re: Extracting daily details

Tue, 20 May 2014 09:53:41 GMT

this is not working 4 me

Re: Extracting daily details

ashwanin — Tue, 20 May 2014 09:57:21 GMT

Can you post your sample qvw.

Re: Re: Extracting daily details

Tue, 20 May 2014 10:19:22 GMT

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.

Re: Extracting daily details

Tue, 20 May 2014 10:34:09 GMT

write the below condition in expression tab:

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