topic Re: How do I create a text object that updates based on user selection? in QlikView

How do I create a text object that updates based on user selection?

tmagdich — Sat, 16 Nov 2024 03:01:59 GMT

I am creating a dashboard from a excel file that deals with employee information. I have seen other dashboards use the text object feature to show updated information at a glance based off of the user selection. I can't seem to figure out how to achieve this.

Re: How do I create a text object that updates based on user selection?

olivetwist — Thu, 11 Jul 2019 12:08:41 GMT

it all depends on the information you want to display. if it is something like "TOTAL SALES" then you would just add a formula like "=sum(sales)" .

Re: How do I create a text object that updates based on user selection?

tmagdich — Thu, 11 Jul 2019 12:11:11 GMT

The information that I want to update are just text, not a numeric value. What formula would I use for that?

Re: How do I create a text object that updates based on user selection?

olivetwist — Thu, 11 Jul 2019 12:13:28 GMT

Can you provide an example? is it like:

Month, User, Login_Date

If i choose a user it shows the month?

Re: How do I create a text object that updates based on user selection?

tmagdich — Thu, 11 Jul 2019 12:18:31 GMT

Employee Name	Division	Region	Employee ID
John Smith	Development	NA	jsmith12

Something similar to this. If the user selects "John Smith", text objects auto update that show this employee's division, region and employee ID.

Re: How do I create a text object that updates based on user selection?

olivetwist — Thu, 11 Jul 2019 12:24:02 GMT

See the attached example

you may want to adjust the "GETSELECTEDCOUNT(field)>0" to "GETSELECTEDCOUNT(field)=1" if you only want it to display when an individual is selected.

Re: How do I create a text object that updates based on user selection?

tmagdich — Thu, 11 Jul 2019 12:35:14 GMT

Exactly what I needed, thank you. Is there an easy way to display a simple dash within the text box is nothing is selected, or more than one employee name is selected?

Re: How do I create a text object that updates based on user selection?

olivetwist — Thu, 11 Jul 2019 12:39:06 GMT

Just add '-' as the "False" return in your IF like below:

=[Employee Name] & '
'&IF(GETSELECTEDCOUNT([Employee Name])=1, Division&' - '&Region&' - '&[Employee ID],'-')

Edit: had to update the formula with "=1"