topic Re: Modifying a text object based on selection in QlikView

Modifying a text object based on selection

tmumaw — Sat, 16 Nov 2024 02:46:44 GMT

Hi All,

I'm having a little problems trying to figure this out. I have a text object with the following value.

Company : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

I need the x's to be filled in based on my selections. My selections are a drilldown. Level1 Company, Level2 service line, Level3 Regions, Level4 Offices,

Any help would be appreciated.

Re: Modifying a text object based on selection

lockematthewp — Fri, 09 Aug 2019 17:32:34 GMT

I think what you are looking for is:

=[Level1 Company] & ', ' & [Level2 Service Line] & ', ' & ….

or you could even determine this value in the script:

Load [Level1 Company],

[Level2 Service Line],

…,

[Level1 Company] & ', ' & [Level2 Service Line] & ', ' & …. as [Company],

...

From ...

Re: Modifying a text object based on selection

tmumaw — Fri, 09 Aug 2019 18:38:23 GMT

What I'm trying to achieve is this:

If they user selects Level1 only, then display Level1. If the user selects Level1 and Level 2 display Level2, if the user selects Level1,Level2 and Level3 display Level3 and so on......

Re: Modifying a text object based on selection

lockematthewp — Fri, 09 Aug 2019 19:22:34 GMT

= if (getselectedcount([Level4])>0, [Level4],

if (getselectedcount([Level3])>0, [Level3],

if (getselectedcount([Level2])>0, [Level2],

if (getselectedcount([Level1])>0, [Level1], '-'))))

Re: Modifying a text object based on selection

tmumaw — Fri, 09 Aug 2019 20:11:58 GMT

That works great. One more question before the weekend starts. I'm using a Cyclic Group for my drill actions. Do you know if anyway to clear selections as you drill around?

Re: Modifying a text object based on selection

Brett_Bleess — Tue, 27 Aug 2019 18:53:46 GMT

Hey Thom, have a look at this Design Blog, might give you another avenue with further functionality, best I have:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Regards,
Brett