Set Analysis function

[#1]

Hi,

I would like to show the data in the chart as project id wise collected value . So how can i write this in expression using Set Analysis.

which function i need to use?

[PrashantSangle · Accepted solution]

Hi,

take Porject Id as dimension

and Sum(Collected Value) as Expression

Regards

[#3]

hi ,

Try like this....

aggr(max(Value),projectID)

or

aggr(sum(Value),projectID)

or

aggr(projectID, -Sum(value)))

[buzzy996]

try this,

=sum({$}value)

[simsondevadoss]

For chart , you can use Project ID as Dimension and Sum(Value) as Expression. Since Qlikview gives only the aggregated output for the dimension

[MK_QSL]

Create a straight Table or Bar/Line Chart

Dimension

[Project ID]

Expression

SUM([Collection Value])