# App Development

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor III

## Find Min year for sum(Bal)>0 in Qliksense

Hi QlikExperts,

How to find Min year for sum(Bal)>0 in Qliksense.

Input Data.

First we have find Min(Year) that has sum(Bal)>0 that will be Year=2016 and store this value in the Variable vMinYear.

tried the below expression but its not working.

Then If(Year < vMinYear, null(), Sum(Bal))

expected output :

Thanks & Regards,

Bharath

Labels (1)
• ### General Question

1 Solution

Accepted Solutions
MVP

Try like below

If(Date >= \$(vMinYear),Sum(Balance), null())

vMinYear =Min({<Date={"=Sum(Balance)>0"}>}Date)

Thanks & Regards,
Mayil Vahanan R
2 Replies
MVP

Try like below

If(Date >= \$(vMinYear),Sum(Balance), null())

vMinYear =Min({<Date={"=Sum(Balance)>0"}>}Date)

Thanks & Regards,
Mayil Vahanan R
Contributor III
Author

@MayilVahanan Thanks its working

Tags
Community Browser