Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Re: Aggr() with set analysis

I used Sum() Function instead of Count(). But it is not making any difference. Still null values are coming.

Highlighted
Esteemed Contributor

Re: Aggr() with set analysis

better if you could share sample file

Sum(aggr(sum({$<Week = {" $(=Week(Start_Date - 7)) "},Week=>}RunTime),Week, Jobs)) /      Sum(aggr(sum({$<Week = {" $(=Week(Start_Date - 7)) "},Week=>}Job_Count), Week, Jobs)

Partner
Partner

Re: Aggr() with set analysis

Hi Meenakshi,

I think you can use a simpler expression by exploiting the power of the sum() function as explained in the Reference Manual:

sum([{set_expression}][distinct][total[<fld {, fld}>]] expression)

Returns the aggregated sum of expression or field iterated over the chart dimension(s).

Can you try to use something like this:

     = sum(RunTime) / sum( total <Jobs, Week> RunTime)


and set the fields Jobs and Week as the dimensions of the chart?


Let me know,


Giacomo