Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Extracting daily details

Hi

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

Ex:

NameStatusINCdate
joncloseda11112-05-14
joncloseda11213-05-14
shalanicloseda11814-05-14
shalanicloseda11918-05-14
shalanicloseda11320-05-14
shalanicloseda11420-05-14
dasuncloseda11520-05-14
dasuncloseda11620-05-14
dasunPendinga12020-05-14
dasunPendinga12120-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)

shalanicloseda11320-05-14
shalanicloseda11420-05-14
dasuncloseda11520-05-14
dasuncloseda11620-05-14
dasunPendinga12020-05-14
dasunPendinga12120-05-14

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

thank you in advance

1 Solution

Accepted Solutions
Not applicable

Re: Extracting daily details

write the below condition in expression tab:

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

View solution in original post

8 Replies
Partner
Partner

Re: Extracting daily details

Hi

Try this

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

I will upload an example later

Regards,
Sergey
Partner
Partner

Re: Re: Extracting daily details

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

Regards,
Sergey
Not applicable

Re: Re: Extracting daily details

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

Partner
Partner

Re: Re: Re: Extracting daily details

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:

Regards,
Sergey
Not applicable

Re: Re: Re: Extracting daily details

this is not working 4 me

Untitled.png

ashwanin
Valued Contributor

Re: Extracting daily details

Can you post your sample qvw.

Not applicable

Re: Re: Extracting daily details

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.

Not applicable

Re: Extracting daily details

write the below condition in expression tab:

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

View solution in original post