Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Expression

Hi 

I have a list box, where, Now I want on selection of that list box value, Value should to display in text box, If there is no selection then Total Sales value should to display in Text Box.

For example, I am using 3 text box to display IT SALES, SCM SALES, FINANCE SALES, But If I select IT, Only IT related sale to display in IT SALES Text BOX, another two box will be 0.

If There is no selection, By default all value will display accordingly.

Thanks.

1 Reply
yilmazmurat
Contributor III
Contributor III

Try this one 

 

IF(GetFieldSelections(Year)='IT_SALES',SUM(SALES),0)