Set Analysis

[#1]

Hi All,

I have a variable vCurrentWave=getfieldselections(CurrentWave)

In expression i am trying to get the count.

=Count({$<WAVE={'$(vCurrentWave)'}>}MYSTERY_SHOPPER)

Also i tried

=Count({$<WAVE={$(vCurrentWave)}>}MYSTERY_SHOPPER)

=Count({$<WAVE={'=$(=vCurrentWave)'}>}MYSTERY_SHOPPER)

if i pass the value directly as below i am getting the count

=Count({$<WAVE={'WAVE2'}>}MYSTERY_SHOPPER)

i tried to display the variable value in text object it is displaying the value as WAVE2

Using the variable i am not getting the result.

Thanks.

[#2]

Try  this

=Count({$<WAVE={$(=vCurrentWave)}>}MYSTERY_SHOPPER)  // not checked the syntax error yet.. but give it a quick try please

[ali_hijazi]

Count({$<WAVE={vCurrentWave}>}MYSTERY_SHOPPER)

[MayilVahanan]

Hi

Try like this

Variable: vCurrentWave

Value:     getfieldselections(CurrentWave) // remove = assign

In text box, try like this $(vCurrentWave)

=Count({$<WAVE={$(vCurrentWave)}>}MYSTERY_SHOPPER)

or

=Count({$<WAVE={'$(vCurrentWave)'}>}MYSTERY_SHOPPER)

[#5]

Thank you for your reply. It doesn't work

[#6]

Thank you for your reply.

Syntax issue

[MK_QSL · Accepted solution]

Provide sample plz

[#8]

Hi Manish,

Your answer worked for me.

=Count({$<WAVE={$(=$(vCurrentWave))}>}MYSTERY_SHOPPER)

Thanks a lot. (By mistake i delete one of my reply)