topic Re: Aggregation in Chart Expression in QlikView

Aggregation in Chart Expression

Tejeswari_123 — Tue, 19 Jul 2022 12:09:45 GMT

Hello Team,

We are working on requirement where we need to display the Value aggregated to only Project name if the Hierarchy level is 2 .

I am trying to calculate aggregated the values based on Project Name, but the aggregated amount is correct only for one row if the Project name is repeating in another row with different Project Number

The only difference between those rows is project number remaining column values are same.

Please find sample data which was given below

Project Name	Required Value
ABC	112
LMN	310
DEF	465

Hierarchy level	Programme	Project Name	Project number	Value	Required Value
3	Progarmme1	ABC	PRJ1	0	112
3	Progarmme1	ABC	PRJ2	112	112
3	Progarmme3	LMN	PGM1	310	310
3	Progarmme4	DEF	PRJ4	465	465
3	Progarmme4	DEF	PRJ3	0	465

I am using below expressions for aggregating the values

Value = if([Hierarchy Level] =3,Sum(aggr((Sum({<[Column]={'xyz'}>}[Amount])),[Project Name]))

I am trying in different ways like using group by in QV script but it doesn't work , Can anyone please help me here ?

Thanks,

Tejeswari

Re: Aggregation in Chart Expression

vijayaganesh_s — Tue, 19 Jul 2022 13:26:20 GMT

Hello Tejeswari,

If you are having the Project Name with the Required Value as a separate table as mentioned in your example then please use only function -> Only(Required Value), this will work only if you are using the Project Name in your visual, attached image for your reference.

BR,

Vijay

Re: Aggregation in Chart Expression

Tejeswari_123 — Tue, 19 Jul 2022 16:23:24 GMT

Hi Vijay,

Required Value is not available in Table , that value is supposed to our expected value . Apologies for the confusion.

Thanks,

Tejeswari

Re: Aggregation in Chart Expression

vijayaganesh_s — Wed, 20 Jul 2022 05:36:42 GMT

Hello Tejeswari,

Thanks for the clarification, please try Sum(Total <[Project Name]>Value), Defining the Total Scope based on the Project Name would help!

BR,

Vijay