topic Re: Text object in QlikView

Text object

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

Hi,

In a text object i have entered this condition

if(GetSelectedCount(AGENCYEVENT.DISTRICT)>0, 'AGENCYEVENT.DISTRICT :'& Concat(GetFieldSelections(AGENCYEVENT.DISTRICT),',') ) & ' '&

I have used this condition for showing filed selections i have total 210 fields right now i have added 200 fields after that it's not taking field name as field showing field name in black color.

Is their any limitation of characters in text object.if yes is their any possibility to do in any other way.please help me to do.

Thanks,

Re: Text object

Anonymous — Sat, 13 Aug 2016 05:27:05 GMT

Post sample image

Re: Text object

ziadm — Sat, 13 Aug 2016 05:47:31 GMT

Try This in the Dimension enable condition

=IF( (GetSelectedCount(Calendar))> 0), SubStringCount(Calendar), '|'), 'Year') ,0 )

Lets assume your Dimension is Year and you want to enable or disable that Dimension based on the user selection of Year Field.

Calendar is Your Table where "Year" is a Record in that Table

Re: Text object

bhavvibudagam — Sat, 13 Aug 2016 05:53:30 GMT

HI Anil,

After 201 line it SHOWS ACCIDENT_WEEKDAY IN BLACK

Re: Text object

bhavvibudagam — Sat, 13 Aug 2016 05:58:10 GMT

i AM WORKING IN REPORT BUILDER.I am applying the condition which is shown on above image in bottom blue color text object.The selection which i have done in filter will appear below.

Re: Text object

ziadm — Sat, 13 Aug 2016 06:07:27 GMT

=IF( (GetSelectedCount(LWCASE))> 0), SubStringCount(LWCASE), '|'), 'ASSIGNED_DIVISION') ,0 )

if ASSIGNED_DIVISION SELECTED THEN enable the Dimension

Re: Text object

vinieme12 — Sat, 13 Aug 2016 06:24:37 GMT

Can you post your full expression?

also you won't need getfieldselection in Concat function

if(GetSelectedCount(AGENCYEVENT.DISTRICT)>0,'AGENCYEVENT.DISTRICT :'& Concat(DISTINCT AGENCYEVENT.DISTRICT,',')) & ' | ' &