Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Creating a Bar chart in Qlikview

I would like to create a bar chart.

I have attached an image of the bar Chart created in Excel.

I want to replicate this chart in Qlikview.

How should I upload the Data? (The P1,P2,P3,P4 and Total Data)?

What do I use as the Dimensions?

What do I use for the Field?

What do I use for the aggregation?

Thanks,

SK

4 Replies
Partner
Partner

Re: Creating a Bar chart in Qlikview

Hi,

You can upload the data into QV in 2 ways,

1 - If the data is static and you are sure it will not change, you can upload the data using INLINE DATA, by clicking EDIT (ctlr + E) and clicking INSERT > LOAD STATEMENT > LOAD INLINE.

2- If the data is dynamic, always changing it is best to import the data then, click EDIT (ctlr + E) > click TABLE FILE.

One important thing you should do is, to give each column a name then in your dimension use SUM function for the VALUE field.

  So say you have named the VALUE field as No. then in the Edit Diemnsion enter SUM(No).

Let me know if this is helpful

Best Regards,

Gabriel

MVP & Luminary
MVP & Luminary

Re: Creating a Bar chart in Qlikview

See this video tutorial


talk is cheap, supply exceeds demand
Not applicable

Re: Creating a Bar chart in Qlikview

Hi,

I am not sure if I should upload the p1, p2. p3, p4 and total in different fields or do they all need to be in the same field.

Then it asks what fields do I need to add to the dimension. Do I add all of the fields(p1, p2. p3, p4 and total)?

After this it asks for Aggregation and field. I have attached an image of the screen  shot to this message.Capture.PNG

Thanks,

SK

Partner
Partner

Re: Creating a Bar chart in Qlikview

Hi,

I will suggest you load th p1,p2,p3,p4 and total together in same field and use this field as dimension and use the second field with the numbers as aggregate as in SUM(value field).

Hope this helps

Best Regards,

Gabriel