Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy

Pivot table Sum of average

Hi All,

Give me the suggestion for the below screen shot. Attached the example file.

qv_doubt1.JPG.jpg

regards,

settu

13 Replies
dharmarasu
Creator
Creator

Hi,

in that above Screen shot showing correct..nothing wrong in it..

In that average showing Average(1267+1281+1277)=1275..ie (1267+1281+1277)/3=1275..Hope this helps..

Dharma

settu_periasamy

Hi Dharmarasu,

Already there is an average for country level. I need the sum of Country average in the dimension level. i.e

if (dimensionality()=0, sum(801 average, 802 average and 803 average). Hope i clear now..

Settu

jonathandienst

Hi

This expression will do it:

=Sum(Aggr(Avg(Sales), Country))

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst

Sorry, correction to the above:

If(Dimensionality() = 0, Sum(Aggr(Avg(Sales), Country)), Avg(Sales))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
settu_periasamy

hi Jonathan,

If we give that expression, the sum value is changed. Already the sum value is correct. i need to change the dimension total only. see the arrow mark in that picture.

dharmarasu
Creator
Creator

pls see this attachment

Dharma

jonathandienst

Did you see my correction?

If(Dimensionality() = 0, Sum(Aggr(Avg(Sales), Country)), Avg(Sales))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
settu_periasamy

Hi Dharmarasu,

i need the result like the below screen shotqvdoubt3.JPG.jpg

settu_periasamy

hi jonathan,

thank you for your expression. It showing the value. but day value shows 0. see the below screen shot.

qvdoubt5.JPG.jpg