topic Re: Dollar Sign Expansion in Nested IF in QlikView

Dollar Sign Expansion in Nested IF

lsteere01 — Tue, 25 Aug 2015 15:10:23 GMT

The following if statement works, until the else portion of the logic is triggered, then I get the message "Error: Error in set modifier ad hoc element list: ',' or ')' expected"

=if(vFrom = 'N/A', Count({<[Transferred To Facility]={$(vTo)}>}CSN), 'Good')

I've narrowed the problem down to the dollar sign expansion. It seems that Qlikview trips up when dollar expansion is used inside a nested IF.

Does anyone have a solution?

Thanks in advance!

Re: Dollar Sign Expansion in Nested IF

petter — Tue, 25 Aug 2015 15:15:32 GMT

What does the vTo variable contain? Do you have some examples of various values it can contain?

Re: Dollar Sign Expansion in Nested IF

settu_periasamy — Tue, 25 Aug 2015 15:23:55 GMT

Hi,

Did you try this/

=if(vFrom = 'N/A', Count({<[Transferred To Facility]={'$(=vTo)'}>}CSN), 'Good')

=if($(vFrom) = 'N/A', Count({<[Transferred To Facility]={'$(=vTo)'}>}CSN), 'Good')

Re: Dollar Sign Expansion in Nested IF

Peter_Cammaert — Tue, 25 Aug 2015 15:30:49 GMT

Could it be that vTo expands to something containing spaces? If so, put the $(vTo) part between quotes.

Re: Dollar Sign Expansion in Nested IF

lsteere01 — Tue, 25 Aug 2015 15:33:20 GMT

Your first example worked perfectly. Thanks!