topic charts in QlikView

charts

Sun, 25 May 2014 08:59:18 GMT

i have an excel and only have one row of value as shown in below image.. from the highlighted two columns i want to generate a chart as shown in the 2nd image.. i did try many ways but i just cant take the expected value.. can some one plz help me...

thank you in advance

Re: charts

ashfaq_haseeb — Sun, 25 May 2014 09:27:11 GMT

Hi,

Can you post your sample file with Excel data.

Regards

ASHFAQ

Re: Re: charts

Sun, 25 May 2014 12:54:41 GMT

sorry 4 getting late this z the test quv n my excel.. i have done nothing actually in the quv cz i want to get this chart done

Re: charts

MarcoWedel — Sun, 25 May 2014 23:24:08 GMT

Hi,

maybe like this?

LOAD
F2          as Date,
[Calls
Hand
< SL*]      as [call answered],
[Calls Aband
< SL**]     as [call abandoned]
FROM [http://community.qlik.com/servlet/JiveServlet/download/535000-107929/icd_contact_service_queue_activity_by_csq_table_en_us_month.xls]
(biff, embedded labels, table is Sheet1$);

just select stacked bar chart:

hope this helps

regards

Marco

Re: charts

Wed, 04 Jun 2014 03:37:50 GMT

sorry for late reply but this worked perfectly thank you so much