Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Swathi
Creator
Creator

how to totals data for rows

i have different types and countries are there , i need totals for each type and countries, some places need total  few rows like that

Swathi_0-1715782215191.png

in the above screenshot we can see i have  group, country, type fields are there, for group is Europe, i need all totals Europe group.  as group europe i have  3 types Totals are there one is 

1.TOTAL

2.TOTAL Power

3.TOTAL Gas

TOTAL means summ of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), irrespetive of which type it is. it will summ of all rows for Group='Europe'

TOTAL Power means sum of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), where Group='Europe' and Type ='Power'

Swathi_0-1715782215191.png

in the above screenshot we can see i have  group, country, type fields are there, for group is Europe, i need all totals Europe group.  as group europe i have  3 types Totals are there in country field only is 

1.TOTAL

2.TOTAL Power

3.TOTAL Gas

TOTAL means sum of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), irrespetive of which type it is. it will sum of all rows for Group='Europe'

TOTAL Power means sum of all {<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF), where Group='Europe' and Type ='Natgas'. 

i tried below formula, but iam not any getting any data it is 0.0 as seen screenshot.

Pick(SrNo,

if(GetFieldSelections (Group)='Europe',
if(Country= 'TOTAL',
{<Year = {$(vYearSelect)}> } $(vPortfolioValue_mCHF),
if(Country='TOTAL Power',
{<Year={$(vYearSelect)},Group={'Europe'},Type={'Power'}>} $(vPortfolioValue_mCHF),
if(Country='TOTAL Gas',
{<Year={$(vYearSelect)},Group={'Europe'},Type={'Natgas'}>} $(vPortfolioValue_mCHF)

)
)

)

),{<Year={$(vYearSelect)},Group={'Europe'}>} $(vPortfolioValue_mCHF))

Kindly help to get these  it's very urgent and important.

@BrunPierre , Please help me.

 

Labels (2)
0 Replies