topic Re: Find Min year for sum(Bal)>0 in Qliksense in App Development

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

bharathkamath28 — Tue, 21 Dec 2021 21:56:36 GMT

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 — Thu, 20 May 2021 08:54:24 GMT

Try like below

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

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

bharathkamath28 — Thu, 20 May 2021 10:49:17 GMT

@MayilVahanan Thanks its working