Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor

Average income with filters

Dear community,

I have the following two custom variables:

  • idvisit
  • income

and the following field:

  • idaction_name

I would now like to calculate the average income, but only for those idvisit that fullfill a certain idaction_name (e.g. idaction_name = 12345).

I assume that I have to use a nested aggregation here, but dont know how to proceed.

Can anyone help?

Thanks so much in advance!!