topic Re: what is this expression do? in QlikView

what is this expression do?

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

Hi all,

SubStringCount(

if( isnull(GetFieldSelections(Dim)),' ' , GetFieldSelections((Dim),'|',20))

, 'Quarter')

what is 20 here ?

can anyone explain this exp?

thanks

Sony

Re: what is this expression do?

vishsaggi — Mon, 06 Aug 2018 18:27:00 GMT

20 represents max number of field values you can select from the field Dim.

Re: what is this expression do?

sunny_talwar — Mon, 06 Aug 2018 20:56:23 GMT

Usually, when you use GetFieldSelections... depending on your user preferences (for instance mine are set at 6).. I will see a comma seperated list of selections up until 6 selections...

My user preference settings

6 selections

But as soon as I select 7... you will see what happens

Now in a lot of cases, this is not a problem, but when you have an adhoc report, you need to see the exact selection values so that you can equate them to a condition and conditionally hide show a dimension or expression....

In order to over-ride the user preferences... you can use the third parameter of the GetFieldSelections function...

But remember, this will only be good up until 20 selections... as soon as you make the 21st selection... you will see the same behavior like before

So, setting a highest possible number based on the number of unique value in your dimension might make sense here.

Does this help?

Best,

Sunny

Re: what is this expression do?

soniasweety — Tue, 07 Aug 2018 06:22:14 GMT

thanks its very nice explanation .