Multiplication for multiple filters

Fri, 21 Oct 2016 20:04:01 GMT

I am trying to multiply 2 filtered sets from 1 Item but can't figure out how to do this.

My variable STATVALUE contains all the data, and my variable VARIABLEID contains the filters. In this case I want to multiply the STATVALUE for VARIABLEID = AVERAGEHEATRATE with the STATVALUE for VARIABLEID = GENMARKETFUELPRICE.

I have tried without sucess

avg( {$<VARIABLEID={'GENMARKETFUELPRICE'}>}STATVALUE * {$<VARIABLEID={'AVERAGEHEATRATE'}>}STATVALUE )

avg( STATVALUE(IF(VARIABLEID='GENMARKETFUELPRICE')) * STATVALUE(IF(VARIABLEID='AVERAGEHEATRATE')) )

These values span over dates so if I split out the average to each piece it works for the monthly level but doesn't compute like I want at the annual level.Below I have

avg( {$<VARIABLEID={'GENMARKETFUELPRICE'}>}STATVALUE) * avg({$<VARIABLEID={'AVERAGEHEATRATE'}>}STATVALUE )

When I compress to the annual level I want to see sum(GENMARKETFUELPRICE(ii)*HR(ii))

Any help with this would be much appreciated.

Re: Multiplication for multiple filters

sunny_talwar — Fri, 21 Oct 2016 20:12:03 GMT

Try like this:

Sum(Aggr(

Avg({$<VARIABLEID={'GENMARKETFUELPRICE'}>}STATVALUE) *

Avg({$<VARIABLEID= {'AVERAGEHEATRATE'}>}STATVALUE)

, Date))

Re: Multiplication for multiple filters

Fri, 21 Oct 2016 21:11:57 GMT

Thank you that worked.

topic Re: Multiplication for multiple filters in QlikView

Multiplication for multiple filters

Re: Multiplication for multiple filters

Re: Multiplication for multiple filters