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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

Amount to display

Hello community,

I would like to set a condition

if sum(poktndd) >0 and IS NOT NULL(LB) => sum(poktndd)

else don't display the amount / sum(poktndd)

Any idea please?

Thanks

13 Replies
sunny_talwar

So like this?

If(Len(Trim(LB) > 0 and Sum(poktndd) > 0, Sum(poktndd))

master_student
Creator III
Creator III
Author

there are errors in your expression

sunny_talwar

Yes my bad, I forgot a parenthesis within my first condition:

If(Len(Trim(LB)) > 0 and Sum(poktndd) > 0, Sum(poktndd))

master_student
Creator III
Creator III
Author

Capture.PNG

sunny_talwar

Is your field name all Upper case?  May be this:

If(Len(Trim(LB)) > 0 and Sum(POKTND) > 0, Sum(POKTND))

These are things we won't know so you have to make sure that you take care of them at your end

master_student
Creator III
Creator III
Author

Thanks for your help sunny. The fields names are correct.

sunny_talwar

So did it work or not?

master_student
Creator III
Creator III
Author

no

sunny_talwar

Have you tried clicking ok to see if you see any result or not? Where are you using this condition? Would be able to share screenshots of your LB and POKTND/poktnd field? To make both our life easier, would you be able to share a sample?