bar chart

[#1]

Dear all,

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

please can any one help me..

[jagannalla]

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

[#3]

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?

[jagannalla]

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

[#5]

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.

[kaushiknsolanki]

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

[#7]

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.

[jagannalla]

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

0

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?

[#9]

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

[#10]

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.