Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI Amit
I had created sample report hopes it helps to you
Please find attachment
Thanks
Mahesh
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;