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: 
Fennrir
Contributor
Contributor

Choosing amount of listed item and KPI default value if nothing selected.

Hello

I'm pretty new to Qlik sense and SQL in general so please bare with me 😉

sales.PNGSo I have this screen and I would like to make it so the user can choose the amount of each selected item. I would also like for the KPI to show 0 if nothing is selected. Any ideas? 

1 Solution

Accepted Solutions
pasi_lehtinen
Partner - Contributor III
Partner - Contributor III

Hi,

Not sure if I understood your request correctly. Please try:

if(GetSelectedCount(ProductName)=0,0,Sum(ListPrice))

This expression will display the sum of list prices in case the user has selected at least one Product, otherwise it will display 0 amount.

View solution in original post

2 Replies
pasi_lehtinen
Partner - Contributor III
Partner - Contributor III

Hi,

Not sure if I understood your request correctly. Please try:

if(GetSelectedCount(ProductName)=0,0,Sum(ListPrice))

This expression will display the sum of list prices in case the user has selected at least one Product, otherwise it will display 0 amount.

Fennrir
Contributor
Contributor
Author

Thanks it worked for the KPI thing!