Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
Creator II
Creator II

Show value in Text Object

I have a text object and List box and Bar chart.

Bar chart shows Expense by Location and List box has Locations listed.

I want the text object to show Expense only when a location is selected from List box or Bar chart ( when one of the bars is selected)

As of now Expense gets displayed only when Location is selected from List box and when I select one of the bars it doesnt show value..is this doable ?

Thank you.

Ex: Location is the dimension in Bar chart and the list box.

In text object I have the below expression:

if(GetFieldSelections([Location])>0,sum([Expense]))


I also tried


if(GetSelectedCount([Location])>0,sum([Expense]))


Thank you.

3 Replies
sunny_talwar

Would you be able to share a sample to show the issue?

sasiparupudi1
Master III
Master III

Please upload a sample

shiveshsingh
Master
Master

May be it is easier to help if you could share the sample!