topic Re: how to construct chart in QlikView

how to construct chart

Tue, 18 Jul 2017 08:37:34 GMT

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

Re: how to construct chart

Sergey_Shuklin — Tue, 18 Jul 2017 08:52:57 GMT

Hello!

This topic will help:

The Crosstable Load

Re: how to construct chart

arvind_patil — Tue, 18 Jul 2017 09:01:15 GMT

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

Re: how to construct chart

Tue, 18 Jul 2017 09:06:11 GMT

must i convert to crosstable like what you shown?

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

Re: how to construct chart

Tue, 18 Jul 2017 09:06:20 GMT

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

Re: how to construct chart

arvind_patil — Tue, 18 Jul 2017 09:52:38 GMT

HI Chee,

I hope it will serve your purpose.

Please find the attachment.

Thanks,

Arvind Patil

Re: how to construct chart

arvind_patil — Tue, 18 Jul 2017 09:54:26 GMT

In More Corrective way is:

Thanks,

Arvind Patil

Re: how to construct chart

balar025 — Tue, 18 Jul 2017 09:58:18 GMT

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

Re: how to construct chart

Sergey_Shuklin — Tue, 18 Jul 2017 17:00:13 GMT

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.

Re: how to construct chart

Sergey_Shuklin — Tue, 18 Jul 2017 17:05:54 GMT

Attachement for description above.

Re: how to construct chart

Wed, 19 Jul 2017 00:32:40 GMT

Hi Sergey,

Thanks for your answer. My question is how do i set filter on that particular sheet. What i want is set the condition for the chart. for example my data got No 1 to No 9.

My first sheet chart i want to always display No 1 data. Sheet 2 - No 2

Re: how to construct chart

Sergey_Shuklin — Wed, 19 Jul 2017 17:07:19 GMT

I didn't actually get what you mean by saying "data got No1 to No9"

But, please, look at the picture below. If it's not what you want so, please, correct me and give more clues to understand you right: