Data comparison

[#1]

Hi Guys,

I am new to qlikview and looking to create a grouped bar chart to show resolved records vs created in a given month for 2017.  My date is as follows -

Record,Create Month-Year,Resolved Month-Year,Status

Record1,Jan-2017,Jun-2017,Resolved

Record2,Feb-2017,<Blank>,Open

Record3,Mar-2017,May-2017,Resolved

Record4,May-2017,May-2017,Resolved

...etc.
Any help you guys can provide would be very helpful.

Thanks.

[Anonymous]

HI Amit

I had created  sample report hopes it helps to you

Please find attachment

Thanks

Mahesh

[jmvilaplanap]

Hi

Try whit this, I changed a little bit you model and I think now is better

DATA:
LOAD * INLINE [
Record,Create Month-Year,Resolved Month-Year,Status
Record1,Jan-2017,Jun-2017,Resolved
Record2,Feb-2017,,Open
Record3,Mar-2017,May-2017,Resolved
Record4,May-2017,May-2017,Resolved
];

NoConcatenate
FinalData:
LOAD
Record,
date#([Create Month-Year], 'MMM-YYYY')        AS Date,
1                                                          AS Created
Resident DATA
WHERE [Create Month-Year] <> '';
Concatenate
LOAD
Record,
date#([Resolved Month-Year], 'MMM-YYYY')  AS Date,
1                                                          AS Resolved
Resident DATA
WHERE [Resolved Month-Year] <> '';

DROP Table DATA;