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.

Anil_Babu_Samineni — Thu, 06 Jul 2017 03:11:56 GMT

How you want to show? Would you help us the expected result

ahaahaaha — Thu, 06 Jul 2017 05:26:31 GMT

Hi,

May be like at attached file?

Regards,

Andrey

kamal_sanguri — Thu, 06 Jul 2017 06:22:38 GMT

you can show this way.

Pls refer the attached QV document. You can definitely modify it the way you want.

Thu, 06 Jul 2017 12:29:30 GMT

Thanks Guys. Either a grouped bar chart or stacked would be fine. Can you copy/paste the script as I have the personal edition of QV.

Fri, 07 Jul 2017 12:13:44 GMT

This will work. Can you provide the script below as I can't open the attachment. Thanks.