topic Re: RE:Date error in QlikView

RE:Date error

Chanty4u — Sun, 07 Feb 2016 11:07:08 GMT

hi all,

What wrng in my expression

my date field as

date

2014-may-05

2014-may-06

2014-may-07

2014-may-08

2014-may-09

2014-may-10

=date(MonthsStart( "date"), 'YYYY-MMM')

i want to display date as :2014-may

how can i get this date.

Re: RE:Date error

marcus_sommer — Sun, 07 Feb 2016 11:11:39 GMT

Try:

=date(MonthStart(date#(date, 'YYYY-MMM-DD')), 'YYYY-MMM')

- Marcus

Re: RE:Date error

Chanty4u — Sun, 07 Feb 2016 11:14:53 GMT

thnx marcus,

Its shwng error in expression

PFA

Re: RE:Date error

marcus_sommer — Sun, 07 Feb 2016 11:33:09 GMT

You tried it with MonthsStart which requirred more than one parameter and therefore throws an error but you need instead MonthStart - to compare:

MonthsStart

MonthStart

Details to their differences could you find within the help.

- Marcus

Re: RE:Date error

Chanty4u — Sun, 07 Feb 2016 12:50:23 GMT

thnx marcus.....even though it is nt gvng any value.. as expression is ok . MonthStart i used dis

Re: RE:Date error

marcus_sommer — Sun, 07 Feb 2016 13:03:37 GMT

I have tried this within a textbox and it's working fine:

=date(MonthStart(date#('2014-may-10', 'YYYY-MMM-DD')), 'YYYY-MMM')

- Marcus

Re: RE:Date error

Sun, 07 Feb 2016 13:16:49 GMT

Hi Suresh,

Can you use the below command in the expression.

=Date(Date#(date,'YYYY-MMM-DD'),'YYYY-MMM')

Thanks,

Sreeman

Re: RE:Date error

Chanty4u — Sun, 07 Feb 2016 13:29:39 GMT

yeah.. its gvng correct now but....we are gvng the date manually ryt.......if my data chnges? how can i ?

Re: RE:Date error

maxgro — Sun, 07 Feb 2016 13:53:53 GMT

replace with the '2014-may-10' with the field name, in the code below datefield

Source:

load * inline [

datefield

2014-may-05

2014-may-06

2014-may-07

2014-may-08

2014-may-09

2014-may-10

];

load

datefield,

date(MonthStart(date#(datefield, 'YYYY-MMM-DD')), 'YYYY-MMM') as newdatefield

Resident Source;

Re: RE:Date error

Chanty4u — Sun, 07 Feb 2016 13:58:06 GMT

thnx maxgro........if i want to do in frnt end. how to do this? without creating new field in bakend?

Re: RE:Date error

marcus_sommer — Sun, 07 Feb 2016 14:08:08 GMT

The manually written date was only to show that the logic and syntax is right - you could it replace directly with your date-field. If you get then no valid result it meant that your date-field contained a different value and/or format then you expect. Maybe it needs then a trim() or it is really a timestamp instead a date and the expressions needs to be adjusted a little bit.

- Marcus

Re: RE:Date error

maxgro — Sun, 07 Feb 2016 14:21:07 GMT

the same expression can work in a chart

you can do a straight table chart with (this is just an example) a

- calculated dimension date(MonthStart(date#(datefield, 'YYYY-MMM-DD')), 'YYYY-MMM') as newdatefield

- expression count(datefield)

this is the script for the example above

Source:

load * inline [

datefield

2014-may-05

2014-may-06

2014-may-07

2014-may-08

2014-may-09

2014-may-10

2015-may-10

];

Re: RE:Date error

Chanty4u — Sun, 07 Feb 2016 14:25:50 GMT

Thnx M G and Marcus. your info is awesome. grt explnatn. .

Re: RE:Date error

Chanty4u — Mon, 08 Feb 2016 04:52:09 GMT

hi,

It is not working alrdy tried dat one.

Thanks

Suresh