topic Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula in QlikView

Error in set modifier ad hoc element list: ',' or ')' expected in formula

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am trying to do the following formula

vVolumeType = 0 or 1 depending on one button

vVolumeTypeText = if($(vVolumeType), 'Volume hL', 'Volume Pallets')

Both of these two formulas work perfectly, but when I put it in a Set Analysis shows the title error.

sum({<Indicador={$(vVolumeTypeText)}>} Valor)

Although the following configuration works:

sum({<Indicador={'Volume hL'}>} Valor) or this configuration sum({<Indicador={'Volume Pallets'}>} Valor)

and I do not know what to do.

If anyone could help me I would be appreciated.

Regards,

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

ahaahaaha — Fri, 26 May 2017 13:44:19 GMT

May be

sum({<Indicador={$(=vVolumeTypeText)}>} Valor)

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

Gysbert_Wassenaar — Fri, 26 May 2017 13:44:25 GMT

Try putting an = character in front of the expression in the variable: =if($(vVolumeType), 'Volume hL', 'Volume Pallets')

And put the dollar expansion in single quotes: sum({<Indicador={'$(vVolumeTypeText)'}>} Valor)

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

hector_munoz — Fri, 26 May 2017 13:44:35 GMT

Hi Bruno,

Try the following:

=Sum({<Indicador={$(#vVolumeTypeText)}>} Valor)

Regards,

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

zebhashmi — Fri, 26 May 2017 13:49:51 GMT

is it a typo that you do not have complete logic check

vVolumeTypeText = if($(vVolumeType), 'Volume hL', 'Volume Pallets')

it should be

vVolumeTypeText = if($(vVolumeType) = 1, 'Volume hL', 'Volume Pallets')

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

Fri, 26 May 2017 14:04:45 GMT

Hi guys,

Thanks a lot for the answers. I tried the three of them and anyone of then works:

sum({<Indicador={$(=vVolumeTypeText)}>} Valor) is still have the same error
=if($(vVolumeType), 'Volume hL', 'Volume Pallets')this formula works only without the = sign (if I put it this formula does not work anymore)
=Sum({<Indicador={$(#vVolumeTypeText)}>} Valor)does not work too even with the = sign.
I tried this too vVolumeTypeText = if($(vVolumeType) = 1, 'Volume hL', 'Volume Pallets'), but is having the same error.

I will try send a mock.

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

Fri, 26 May 2017 14:10:22 GMT

Hi guys,

I put a link for an mock here:

mockt.qvw

Regards,

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

sudeepkm — Fri, 26 May 2017 14:48:46 GMT

could you please try like below:

in your Variable Overview:

vVolumeTypeText

=if($(vVolumeType) = 1, 'Volume hL', 'Volume Pallets')

vVolume_error

Sum({<Indicador={"$(vVolumeTypeText)"}>} Valor)

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

vishsaggi — Fri, 26 May 2017 15:03:34 GMT

Check this may be?

Re: Error in set modifier ad hoc element list: ',' or ')' expected in formula

Fri, 26 May 2017 16:53:26 GMT

Many thanks,

Works perfectly.

Even though I do not understood why. I saw that in some cases we use = in variable and $ and another, could you, please, tell me why this difference?