how to construct chart

[#1]

Dear Team,

I have similar data as shown below. and i manage to create a chart in excel correctly. But in qlikview, what should i put under dimension and expression? i dont seem able to make it works in qlikview

[Sergey_Shuklin]

Hello!

This topic will help:

The Crosstable Load

[arvind_patil]

Hi Chee,

I want to know about your data source  if you got it from excel . Then name 1 st column in excel as ID or relevant to data.

After that convert it into cross table and use as like you.

Thanks,

Arvind Patil

[#4]

must i convert to crosstable like what you shown?

My data structure is same like what shown in my screenshot in excel

[#5]

My data structure is same like what shown in my screenshot in excel

[arvind_patil]

HI Chee,

I hope it will serve your purpose.

Please find the attachment.

Thanks,

Arvind Patil

[arvind_patil]

In More Corrective way is:

Thanks,

Arvind Patil

[balar025]

You Need add below line before your load statement of data.

Crosstable(Dimension,Value,1)

Load

ID,

ValueA,

ValueB,

ValueC,

ValueD,

ValueE

Source Data;

then you can use Dim and ID as dimension and sum(Value) as Expression.

Thanks

[Sergey_Shuklin]

Just follow this steps:

Step 1. Modify your script with CrossTable() function

Step 2. Create a Bar Chart with two dimensions "vals" and "nums". Create an expression "sum(facts)"

And now we have the same picture as at your screenshot.

[Sergey_Shuklin]

Attachement for description above.