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
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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: 
eyefault
Contributor
Contributor
‎2023-03-21 07:37 AM

Kpi with a condition

Hi guys,

Data is similar a show below;

Period Revenue
202301 20
202301 30
202301 40
202302 50
202302 60
202303 70

 

How can be function can I show the total revenue in kpi in the maximum period condition.

Query result should be used 70 in KPI

Labels (1)
Labels
847 Views
0 Likes
1 Reply
Or
MVP
MVP
‎2023-03-21 08:07 AM

FirstSortedValue(Revenue, -Period)

831 Views
0 Likes