topic Re: INDEX function not working in App Development

INDEX function not working

TIGERMG — Tue, 09 May 2023 08:06:36 GMT

Hi ALL,

I'm created 1 table with 12 columns and want to show dem on show / hide way on selection on MONTHYEAR fields.

so, for column condition I put below expression, it is working for any 6 selection in MONTHYEAR field but if i select any other MONTHYEAR field it wont work....... I found the issue that is Index become zero after 7 select.

If(Len(GetFieldSelections(MONTHYEAR))>0 and index(GetFieldSelections(MONTHYEAR), '$(vJan)')>0 , 1,0)

please suggest . Thank you in advance.

Re: INDEX function not working

tresB — Tue, 09 May 2023 08:37:18 GMT

getfieldselections() has a third parameter for max value which is by default 6. If you need more values to be considered, you have to explicitly pass it. Try like:

If(Len(GetFieldSelections(MONTHYEAR , ',' , 100))>0 and index(GetFieldSelections(MONTHYEAR , ',' , 100), '$(vJan)')>0 , 1,0)

Re: INDEX function not working

TIGERMG — Tue, 09 May 2023 09:07:51 GMT

Hi Tresesco,

Its working as per the requirement.

Thank you🙂 so much for your help.

Re: INDEX function not working

TIGERMG — Tue, 16 May 2023 13:09:30 GMT

Hi Tresesco,

I have created 1 field in backend i.e ACTUALS and again 1 table with 12 columns and want to show dem on show / hide way on selection on ACTUALS fields.

GetFieldSelections is not working so i take below GetCurrentSelections, its working but aging same not more than 6 selection even applying the same expression which u suggest earlier.

If(Len(GetCurrentSelections(ACTUALS,',',100))>0 and index(GetCurrentSelections(ACTUALS,',',100), '$(v1)')>0 , 1,0)

Please suggest.

Re: INDEX function not working

tresB — Wed, 17 May 2023 04:24:27 GMT

@TIGERMG , GetCurrentSelections() is not exactly similar to the earlier one. It doesn't have a field parameter, of course, you need all fields selection, so there is no point mentioning one. I suggest to always check qlik's official help site once you get a hint from community to understand better and resolve. Please check here : GetCurrentSelections | QlikView Help

For this case, you may try like:

=GetCurrentSelections(',','|','@',100)