topic Re: Data comparison in QlikView

Data comparison

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Data comparison

Anonymous — Tue, 11 Jul 2017 08:23:13 GMT

HI Amit

I had created sample report hopes it helps to you

Please find attachment

Thanks

Mahesh

Re: Data comparison

jmvilaplanap — Tue, 11 Jul 2017 08:45:12 GMT

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;