topic Re: Need Help?? in QlikView

Need Help??

paulwalker — Wed, 11 Mar 2015 15:33:39 GMT

Hi All,

How to get current date records in Script level.

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

is anything wrong???

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

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

Thanks in Advance...

Re: Need Help??

MK_QSL — Wed, 11 Mar 2015 15:37:29 GMT

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

Re: Need Help??

Wed, 11 Mar 2015 15:38:51 GMT

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

Re: Need Help??

Anonymous — Wed, 11 Mar 2015 15:43:42 GMT

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);

Re: Need Help??

maxgro — Wed, 11 Mar 2015 15:44:25 GMT

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]);

Re: Need Help??

Anonymous — Wed, 11 Mar 2015 15:50:23 GMT

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);

Re: Need Help??

awhitfield — Wed, 11 Mar 2015 15:57:37 GMT

LOAD Id,
[Open date],
Amount
FROM

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

Re: Need Help??

paulwalker — Wed, 11 Mar 2015 16:03:20 GMT

Hi All,

Thanks for Response..

Actually i have done same thing...

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

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

Re: Need Help??

awhitfield — Wed, 11 Mar 2015 16:07:27 GMT

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

Andy