Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

The TOTAL default column for measure is 0 when...

....I use IF statements in the calculation. In my case I have month on rows and I do calculation for actual month and two month ahead. the rest of the month is 0. BUT I would like to have the TOTAL sum for the three months I have.

if ( trim([Kalender månad]) = trim(TodayOne) Sum (Budget)*0.10,
if ( trim([Kalender månad]) = trim(TodayTwo) ,Sum (Budget)*0.25,
if ( trim([Kalender månad]) = trim(TodayThree) ,Sum (Budget)*0.50,0)))



regards mikael

1 Reply
MVP
MVP

The TOTAL default column for measure is 0 when...

Perhaps this?

sum(aggr(
if ( trim([Kalender månad]) = trim(TodayOne) ,Sum (Budget)*0.10,
if ( trim([Kalender månad]) = trim(TodayTwo) ,Sum (Budget)*0.25,
if ( trim([Kalender månad]) = trim(TodayThree),Sum (Budget)*0.50,0))),[Kalender månad]))