topic Re: Set Analysis in QlikView

Set Analysis

Tue, 22 Jul 2014 08:04:10 GMT

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.

Tue, 22 Jul 2014 08:22:22 GMT

Try this

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

ali_hijazi — Tue, 22 Jul 2014 08:24:05 GMT

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

MayilVahanan — Tue, 22 Jul 2014 08:26:54 GMT

Try like this

Variable: vCurrentWave

Value: getfieldselections(CurrentWave) // remove = assign

In text box, try like this $(vCurrentWave)

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

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

Tue, 22 Jul 2014 08:27:00 GMT

Thank you for your reply. It doesn't work

Tue, 22 Jul 2014 08:27:18 GMT

Thank you for your reply.

Syntax issue

MK_QSL — Tue, 22 Jul 2014 08:27:45 GMT

Provide sample plz

Tue, 22 Jul 2014 09:56:16 GMT

Hi Manish,

Your answer worked for me.

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

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