Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.