# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
New Contributor III

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

 Dimensions Expressions Group Place City %OP Avg%Op_Group J I NR 014 Horná Kráľová 27,00% 27,47% J I NR 015 Tlmače 28,80% 27,47% J I NR 019 Jarok 30,18% 27,47% J I NR 020 Mojmírovce 24,21% 27,47% J I NR 022 Hronské Kľačany 26,56% 27,47% J I NR 025 Čeľadice 30,28% 27,47% J I NR 027 Hájske 25,77% 27,47% J I NR 032 Jedľové Kostoľany 28,23% 27,47% J I NR 034 Žitavany 29,13% 27,47% J I NR 129 Dolné Štitáre 25,05% 27,47% J I NR 137 Lovce 26,98% 27,47% J I NR Total - 27,12% J II NR 012 Báb 18,39% 24,93% J II NR 013 Báb 28,45% 24,93% J II NR 018 Lužianky 25,76% 24,93% J II NR 125 Podhorany Bádice 27,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)

• ### Expressions

1 Solution

Accepted Solutions
MVP

## 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
MVP

## 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))```
New Contributor III

thank you. 🙂