Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharathkamath28
Contributor III
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.

bharathkamath28_0-1621498380794.png

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 :

bharathkamath28_1-1621498640107.png

Thanks & Regards,

Bharath

 

Labels (1)
1 Solution

Accepted Solutions
MayilVahanan

HI @bharathkamath28 

Try like below

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

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI @bharathkamath28 

Try like below

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

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
bharathkamath28
Contributor III
Contributor III
Author

@MayilVahanan Thanks its working