Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

InputSUM expression

Dear community,

Attached herewith a sample document, the expression as shown below is not working.

FY column :

=if(Column(3)>0, inputsum(FY))


How could i get the yellow highlighted line only?

Thanks,

Chanel

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You are right, I missed a small thing. PFA

View solution in original post

4 Replies
tresesco
MVP
MVP

May be like attached sample

Not applicable
Author

Appreciate your prompt response,

may i know why the min become 1?

It should be 0...

Thanks,

Chanel

tresesco
MVP
MVP

You are right, I missed a small thing. PFA

Not applicable
Author

Awesome! Thanks for your kindly help!