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

[Fennrir]

Hello

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

So 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? 

[pasi_lehtinen · Accepted solution]

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]

Thanks it worked for the KPI thing!