Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

paulwalker
Contributor

Need Help??

Hi All,

How to get current date records in Script level.

i have done like this condition.... where datefield>=today()

is anything wrong???

                                                                                                                                       

IdOpen dateAmount
1003/11/2015100
1013/11/2015100
1023/11/2015200
1033/11/201523
1043/11/201545
1053/11/201567
1063/11/201590
1073/11/20152
1083/11/20156
1093/11/20159
1103/11/201510
1113/11/2015
1123/11/201525
1133/11/201550
1143/11/201512
1151/28/201523
1161/29/201551
1178/28/201380
1189/1/201390
1199/22/20139
1209/30/20137
12110/21/201312
12210/29/201310

i want sow only today's date records only.....  3/11/2015

Thanks in Advance...

1 Solution

Accepted Solutions
MVP
MVP

Re: Need Help??

LOAD Id,

     [Open date],

     Amount

FROM

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

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

where Floor(today())=floor([Open date]);

View solution in original post

8 Replies
MVP
MVP

Re: Need Help??

where Date#(datefield,'D/M/YYYY')=Date#(today(),'D/M/YYYY')

Not applicable

Re: Need Help??

Have you tried where date#(datefield,'m/d/yyyy')<=today()?

maverjannet
Valued Contributor

Re: Need Help??

Hi,

Try

SET vDate = date(today(),'DD/MM/YYYY');

LOAD * INLINE [

    ID, Open Date, Amount

    100, 3/11/2015, 100

    101, 3/11/2015, 100

    102, 3/11/2015, 200

    103, 3/11/2015, 23

    104, 3/11/2015, 45

    105, 3/11/2015, 67

    106, 3/11/2015, 90

    107, 3/11/2015, 2

    108, 3/11/2015, 6

    109, 3/11/2015, 9

    110, 3/11/2015, 10

    111, 3/11/2015,

    112, 3/11/2015, 25

    113, 3/11/2015, 50

    114, 3/11/2015, 12

    115, 1/28/2015, 23

    116, 1/29/2015, 51

    117, 8/28/2013, 80

    118, 9/1/2013, 90

    119, 9/22/2013, 9

    120, 9/30/2013, 7

    121, 10/21/2013, 12

    122, 10/29/2013, 10

]where [Open Date]<=$(vDate);

MVP
MVP

Re: Need Help??

LOAD Id,

     [Open date],

     Amount

FROM

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

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

where Floor(today())=floor([Open date]);

View solution in original post

maverjannet
Valued Contributor

Re: Need Help??

SET vDate = date(today()-1,'DD/MM/YYYY');

LOAD Id,

     [Open date],

     Amount

FROM

[SampleData.xlsx]

(ooxml, embedded labels, table is INDIA) where [Open date]>=$(vDate);

Partner
Partner

Re: Need Help??

LOAD Id,
[Open date],
Amount
FROM

(
ooxml, embedded labels, table is INDIA)
WHERE [Open date] = TODAY();

paulwalker
Contributor

Re: Need Help??

Hi All,

Thanks for Response..

Actually i have done same thing...

May be date format issue's.................

Anyway thank you All...............

Partner
Partner

Re: Need Help??

Could be, does the date format of the source match the QVW, the dates in the example above are MM/DD/YYYY etc

Andy