topic Re: Show value in Text Object in QlikView

Show value in Text Object

BI_Dev — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Show value in Text Object

sunny_talwar — Thu, 15 Mar 2018 13:54:48 GMT

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

Re: Show value in Text Object

sasiparupudi1 — Fri, 16 Mar 2018 08:45:38 GMT

Please upload a sample

Re: Show value in Text Object

shiveshsingh — Fri, 16 Mar 2018 09:04:04 GMT

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