This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
How to find Min year for sum(Bal)>0 in Qliksense.
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,
Try like below
If(Date >= $(vMinYear),Sum(Balance), null())
View solution in original post
@MayilVahanan Thanks its working