Help me in getting output?

[durgabhavani]

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

[Anonymous · Accepted solution]

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

[anbu1984]

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

[qlikviewwizard]

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

[durgabhavani]

Its working! Thanks Everyone!