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

[bharathkamath28]

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

[MayilVahanan · Accepted solution]

HI @bharathkamath28 

Try like below

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

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

[bharathkamath28]

@MayilVahanan Thanks its working