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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
userpd_2021
Contributor III
Contributor III

How to get Total Value in the KPI when no field selected

Hi below is the expression that I used to compare the data in the UI. But there no selection the KPI shows Zero value.But I want to display the over all total value if there's no selection

Sum({<Apple={"$(=GetFieldSelections(Apple))"},[=Upper(Mango)]={"$(=GetFieldSelections(Apple))"}>} Value)

Or Is there a way to do the same from the back end ? script editor side

 

Labels (4)
0 Replies