topic Re: bar chart in QlikView

bar chart

Wed, 07 Nov 2012 10:00:36 GMT

Dear all,

i am new to qlikview.i am not getting how to make bar chart..

please can any one help me..

Re: bar chart

jagannalla — Wed, 07 Nov 2012 10:16:15 GMT

Hello,

Load your table data into qlikview. Say for example

Load Product, Sales form Prod.qvd;

- Now take dimension as Product and expression as Sum(sales) in bar chart.

- Remember bar chart and grid chart considers only two dimensions. Pie, Line, Scatter chart considers two dimensions.

Cheers!!

Jagan Nalla

Re: bar chart

Wed, 07 Nov 2012 10:53:31 GMT

Dear Nalla,

Thanks for reply.

my table contain hourly visitors records.it is in only one column 24 records.i want to make x-axis 0-23 hours limit.and in y-axis visitors of each hour.is there need of any expression to do that?

Re: bar chart

jagannalla — Wed, 07 Nov 2012 11:25:06 GMT

Snehal,

Take Timestamp column in dimension and expression as =count(visitors). If you are not clear please attache sample data or file with sample data.

Cheers!!

Jagan

Re: bar chart

Fri, 09 Nov 2012 08:13:58 GMT

Dear Nalla,

i followed which you told.but in bar chart it showing no data to display.and i am using qlikview personal edition so even i attch file you will not able to open.

my data is only one column which has the number of visitors came in that perticular hour.so rows are 24.

can you give step by step procesure to do that.

thanks.

Re: bar chart

kaushiknsolanki — Fri, 09 Nov 2012 08:26:00 GMT

Dear Shenal,

Do upload your application, we can open that. And also tell us how you want your bar graph to look like.

Once we solve we will give u steps to achieve the same.

Regards,

Kaushik Solanki

Re: bar chart

Fri, 09 Nov 2012 09:34:07 GMT

Dear Kaushik Solanki

i have uploaded my qlikview file.It has 2 tables.

1.Hourly visitors of today.(tHour%Table)

2.Hourly visitors of yesterday.(yHour%Table)

i want to do 2 bar chart with X-axis 0-23 (24 hours), Y-axis visitors of per hour.(which is there in each table)

Thank you.

Re: bar chart

jagannalla — Fri, 09 Nov 2012 09:47:23 GMT

Snehal,

How can this possible without any timestamp columns ?

I understood that you have number of visitors of today and yesterday. But my question is how to know that the particular number of visitors for particular time.

For example:

In your data you have

tHour%Table

194

232

244

288

....

...

- How to know that 0,194,232 vistiors for which hour.

- I mean we need to know that 194 belongs 1 hour ,232 belongs to 2nd hour and 288 belongs to nth hour.

What is the logic you are following to know this information?

Re: bar chart

Fri, 09 Nov 2012 10:08:15 GMT

Hai Sneha,

Creating a bar chart needs to have a dimension ,with out you cant create it.

As Jagan said you follow him.

Thanks,

Rathish Reddy

Re: bar chart

Fri, 09 Nov 2012 10:17:27 GMT

Dear Nalla

i wrote one php script which gives output in xml doc.that php i am importing in qlikview.

query fetching data in ascending order like hour0 1st n hour23 last like wise.while importing in qlikview i am getting value in asending oly.if the value of hour3 is less than hour0 then it will come fast like that.but after doing bar chart taking 1 st dimension tHour%Table, i am getting in x-axis correct value.i mean to say hour0 say it is 2000 that it self and hour3 say 200 that it self.

Re: bar chart

Fri, 09 Nov 2012 10:38:45 GMT

Dear Rathish Reddy

Thanks for reply.

Re: bar chart

jagannalla — Fri, 09 Nov 2012 10:40:38 GMT

Snehal,

If that is the case load below script. In bar chart take the dimension as tHour and in expression =Sum(tHour%Table).

tHour:
LOAD RowNo()-1 as tHour,tHour%Table
FROM [http://localhost/carwale/report12.php?txtaid=1590203679] (XmlSimple, Table is [xml/Report/today/tHour]);
yHour:
LOAD RowNo()-1 as yHour,yHour%Table
FROM [http://localhost/carwale/report12.php?txtaid=1590203679] (XmlSimple, Table is [xml/yesterday/yHour]);

Hope it helps you!!!!

Cheers!!

Jagan

Re: bar chart

Fri, 09 Nov 2012 10:56:13 GMT

Dear Jagan

Thank you so much.i got it.it really helped me.