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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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)