I need staright table

[mshailaja]

Hi

I have date field coming from June 2016  having incidents and problems  raised for example

NO            TYPE    date raised         Summary               Group

IN211         I            02-02-2015       UAT-PRD                  Admin

IN345        P           24-01-2014          DEV-UAT                  ADMIN

IN219         I            12-03-2013         PRD_UAT                  DeV

IN345        P           02-02-2016          DEV-UAT                      ADMIN

IN211         I            22-07-2016          DEV-UAT                  ADMIN

IN345        P            11-07-2016           DEV-UAT                  DEV

IN211         I            13-07-2015           DEV-UAT                  ADMIN

IN345        P          14-07-2016            UAT-PRD                  DEV

IN211         I            16-07-2016         DEV-UAT                  ADMIN

IN345        P            17-07-2016         DEV-UAT                  DEV

Hi

I need staright table  with dimensions as date,NO and Summary

In Dimension(OpenDate) i need the date coming from July2016

Can anyone help me?

[oknotsen]

And what exactly is your problem?

What did you try so far?

Could you share us your .QVW file so we do not have to do everything?

[qlikview979]

Hi Shailaja,

What is your Exact requirement? What is your Expected output?In your source no "OpenDate" Field.

Regards

[MayilVahanan]

Hi

Try like this

LOAD *, MonthName([date raised]) as MonthName INLINE [

NO,TYPE,date raised,Summary,   Group

IN211,I,02-02-2015,   UAT-PRD, Admin

IN345,P,  24-01-2014, DEV-UAT, ADMIN

IN219,I,12-03-2013,PRD_UAT, DeV

IN345,P,  02-02-2016, DEV-UAT,ADMIN

IN211,I,22-07-2016, DEV-UAT, ADMIN

IN345,P,11-07-2016,  DEV-UAT, DEV

IN211,I,13-07-2015,  DEV-UAT, ADMIN

IN345,P, 14-07-2016,UAT-PRD, DEV

IN211,I,16-07-2016,DEV-UAT, ADMIN

IN345,P,17-07-2016,DEV-UAT, DEV

];

date raised	NO	Summary	=Only({<MonthName = {'Jul 2016'}>}[date raised])
11-07-2016	IN345	DEV-UAT	11-07-2016
14-07-2016	IN345	UAT-PRD	14-07-2016
16-07-2016	IN211	DEV-UAT	16-07-2016
17-07-2016	IN345	DEV-UAT	17-07-2016
22-07-2016	IN211	DEV-UAT	22-07-2016

Exp: =Only({<MonthName = {'$(=MonthName(Today()))'}>}[date raised])

[qlikview979]

Hi

May be help full  this

Dimension:-NO,date raised,Summary

Expression:- Only({<MONTH = {'Jul-2016'}>}[date raised])

T1:

LOAD * INLINE [

NO,TYPE,date raised,Summary,   Group

IN211,I,02-02-2015,   UAT-PRD, Admin

IN345,P,  24-01-2014, DEV-UAT, ADMIN

IN219,I,12-03-2013,PRD_UAT, DeV

IN345,P,  02-02-2016, DEV-UAT,ADMIN

IN211,I,22-07-2016, DEV-UAT, ADMIN

IN345,P,11-07-2016,  DEV-UAT, DEV

IN211,I,13-07-2015,  DEV-UAT, ADMIN

IN345,P, 14-07-2016,UAT-PRD, DEV

IN211,I,16-07-2016,DEV-UAT, ADMIN

IN345,P,17-07-2016,DEV-UAT, DEV

];

NoConcatenate

T2:

load

NO, 

TYPE,

Date(Date#([date raised],'DD-MM-YYYY'),'MMM-YYYY') as MONTH ,

[date raised],

Summary,

Group

Resident T1;

DROP Table T1;

[mshailaja]

Hi

the data from the date filed  and also in GMT Time and data is very huge,

so i dnt want to do in inline load

[mshailaja]

Actually i need incidents(NO) and problems(NO)  with seperate straight tablesfrom the month of june 2016 and  the date field coming from june 2016 , i need master calender associated with date raised field, i want also  dateraised Incident no and dateraised problem no  as columns , How? any one please help

[mshailaja]

Hi , I need previous month data

and also i need master calender starting from june2016 associated with the dateraised

Please help me