Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
janturon
New Contributor III

New Expression - % average of % expression values based on Dimension

DimensionsExpressions
GroupPlaceCity%OPAvg%Op_Group
J I NR014Horná Kráľová27,00%27,47%
J I NR015Tlmače28,80%27,47%
J I NR019Jarok30,18%27,47%
J I NR020Mojmírovce24,21%27,47%
J I NR022Hronské Kľačany26,56%27,47%
J I NR025Čeľadice30,28%27,47%
J I NR027Hájske25,77%27,47%
J I NR032Jedľové Kostoľany28,23%27,47%
J I NR034Žitavany29,13%27,47%
J I NR129Dolné Štitáre25,05%27,47%
J I NR137Lovce26,98%27,47%
J I NRTotal-27,12% 
J II NR012Báb18,39%24,93%
J II NR013Báb28,45%24,93%
J II NR018Lužianky25,76%24,93%
J II NR125Podhorany Bádice27,10%24,93%

 

Hello, I have table see above....

 

%OP is this expression:

= (Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'604'}>}MDD)
-
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD))
/
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD)

 

I need help with create expression  Avg%Op_Group.

It means average %OP for Dimension "Group".

Labels (3)
1 Solution

Accepted Solutions

Re: New Expression - % average of % expression values based on Dimension

May be try this

=Avg(TOTAL <Group> Aggr(
(Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'604'}>}MDD)
-
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD))
/
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD)

, Group, Place, City))
2 Replies

Re: New Expression - % average of % expression values based on Dimension

May be try this

=Avg(TOTAL <Group> Aggr(
(Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'604'}>}MDD)
-
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD))
/
Sum({<Rok={$(vsuc)},Mesiac={$(vmaxmes)},UCET_SYN={'504'}>}MDD)

, Group, Place, City))
janturon
New Contributor III

Re: New Expression - % average of % expression values based on Dimension

thank you. 🙂