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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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!