Bar Chart: Trying to compare volume data

Tue, 05 Jul 2011 17:39:21 GMT

Hi All,

The task wants me to show the volume for change orders by project manager and the purchase orders by vendor. Is it possible to put this on the same chart? Also I have to show grouping by managing office and vendor.

I don't think the expressions I have - count(changeorder_num) and count(purchaseorder_num) does this? Plus I have to group by managing office and vendor. So far I have made project manager a dimension and the count(changeorder_num) and count(purchaseorder_num) my expressions. To show grouping by managing office and vendor I used the group feature - the cyclic one...is this correct? I've attached a screen shot of what I have so far.

I would appreciate any help as I have this task to complete as part of an interview process and I have never used QV before. Just learning as I go! Any help would be fantastic. Thank you!!

Bar Chart: Trying to compare volume data

kaushiknsolanki — Wed, 06 Jul 2011 05:55:46 GMT

Hi,

Can you please send me the qvw file. with your desired output in a excel sheet.

Regards,

Kaushik Solanki

topic Bar Chart: Trying to compare volume data in QlikView

Bar Chart: Trying to compare volume data

Bar Chart: Trying to compare volume data