topic Re: Advance aggregation for Line chart in QlikView in QlikView

Advance aggregation for Line chart in QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

For example i have a flat table of country, salary.

Then out of this, i created the following.

Country Min Median Max

SG 100 300 450

USA 50 100 300

UK 150 300 500

In this table, there is country dimension and in the expression, i have 3 individual calculations for Min, Median and Max.

I need to display them through a line chart where each country will be represented with 1 line with 3 data points representing Min(Salary), Median(salary) and Max(Salary).

Seems simple but a bit tricky. Really appreciate your help.

Thanks.

Re: Advance aggregation for Line chart in QlikView

MK_QSL — Wed, 05 Apr 2017 09:27:09 GMT

Something like below?

Data:

Load * Inline

[

Country, Sales

A, 100

A, 120

A, 300

A, 400

B, 200

B, 220

B, 120

B, 150

C, 400

C, 200

C, 150

C, 300

];

Load * Inline

[

Dim

Min

Medium

Max

]

Create a Line Chart

Dimension

Dim

Country

Expression

IF(Dim = 'Min', Min(Sales),

IF(Dim = 'Medium', Median(Sales),

IF(Dim = 'Max', Max(Sales))))

Re: Advance aggregation for Line chart in QlikView

ahaahaaha — Wed, 05 Apr 2017 09:31:26 GMT

ЗДРАВСТВУЙ,

смотрите прикрепленный файл.

С Уважением,

Андрей

Re: Advance aggregation for Line chart in QlikView

Anonymous — Wed, 05 Apr 2017 09:34:23 GMT

THANK YOU SO MUCH SIR!!!!!!

EXACTLY WHAT I NEED!!! Bless you