topic Re: Set Analysis function in QlikView

Set Analysis function

Wed, 01 Apr 2015 11:41:29 GMT

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 — Wed, 01 Apr 2015 11:44:18 GMT

Hi,

take Porject Id as dimension

and Sum(Collected Value) as Expression

Regards

Wed, 01 Apr 2015 11:45:14 GMT

hi ,

Try like this....

aggr(max(Value),projectID)

aggr(sum(Value),projectID)

aggr(projectID, -Sum(value)))

buzzy996 — Wed, 01 Apr 2015 11:49:18 GMT

try this,

=sum({$}value)

simsondevadoss — Wed, 01 Apr 2015 11:51:00 GMT

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 — Wed, 01 Apr 2015 11:54:18 GMT

Create a straight Table or Bar/Line Chart

Dimension

[Project ID]

Expression

SUM([Collection Value])