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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Prithika
Contributor III
Contributor III
‎2023-08-25 05:39 AM

KPI

HELLO

Is there any expression that sums only negative value or only positive values?

i have a dataset in which the expanse of the company is in negative value and income is in positive value. i need to show only expanse value in one kpi and income value in one kpi is it possible.

Labels (1)
Labels
728 Views
0 Likes
1 Reply
vikasmahajan
MVP
MVP
‎2023-08-25 05:47 AM

Hi ,

You can take only positive values like :

Sum({< Value = {">0"} >} Value)

This is sum only positive numbers only.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
724 Views
0 Likes