Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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]))