topic Re: Help me in getting output? in QlikView

Help me in getting output?

durgabhavani — Mon, 11 May 2015 06:06:29 GMT

Hi All,

I have one field as below:

Time

4/22/2015 7:06:01 AM

3/20/2015 4:01:01 AM

3/20/2015 3:01:01 AM

2/12/2015 5:01:01 AM

1/15/2015 7:06:01 AM

2/10/2015 6:01:01 AM

2/14/2015 7:04:01 AM

1/08/2015 5:01:01 PM

Now i need to retrieve monthname, monthnumber and year from the above field values.

As I am planning to use monname as dimension in the barchart.

Thanks,

Durga

Re: Help me in getting output?

Anonymous — Mon, 11 May 2015 06:11:18 GMT

Hi,

Try this

month(Time) as Month,
num(month(Time)) as MonthNumber,
year(Time) as Year;
load * Inline [
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
];

Regards,

Greeshma

Re: Help me in getting output?

anbu1984 — Mon, 11 May 2015 06:18:39 GMT

Load
month(Time) as Month,
num(month(Time)) as MonthNumber,
year(Time) as Year;
load Timestamp#(Time,'MM/DD/YYYY hh:mm:ss TT') As Time Inline [
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
];

Re: Help me in getting output?

qlikviewwizard — Mon, 11 May 2015 06:21:08 GMT

Hi durgabhavani,

Check this

Table1:
LOAD month(Time) as Month,
num(month(Time)) as MonthNumber,
year(Time) as Year;
LOAD * INLINE[
Time
4/22/2015 7:06:01 AM
3/20/2015 4:01:01 AM
3/20/2015 3:01:01 AM
2/12/2015 5:01:01 AM
1/15/2015 7:06:01 AM
2/10/2015 6:01:01 AM
2/14/2015 7:04:01 AM
1/08/2015 5:01:01 PM
];

Re: Help me in getting output?

durgabhavani — Mon, 11 May 2015 06:34:21 GMT

Its working! Thanks Everyone!