Need All sheets to be displayed upon selections???

[sandeepprasad_j]

HI Experts ,

I am attaching qvw file for your reference

MY problem is when i am making multiple selection upto 6 ,the  6 sheets are being displayed nicely on the tab ,if i make more than 6 selection ,nothing is being displayed.

Attaching you a qvw file for the reference .

Can anyone please help me on this ...

Regads,

Sandeep.

[prasad_dumbre]

Hi Sandeep,

GetFieldSelection function which you have used, by default returns on upto 6 selection. If you want it to return more than that. They specify so explicitly.

eg:

getfieldselections ( Year, '; ' , 10 )

[alexandros17]

The problem is that when you select more than 6 values the function getfieldselection thinks in another way: excludes unselected values (not value, value ...) so you have to manage the problem in this way:

getfieldselections ( field, 'separator ' , number of selectable elements )

hope it helps

[sandeepprasad_j]

Can u please explain me via the qvw file which i had supplied

Thanks a ton in advance

Sandeep

[sandeepprasad_j]

HI Alexandros,

Can u please explain me via the qvw file which i had supplied

Thanks a ton in advance

Sandeep

[Sokkorn]

Hi Sandeep,

Try to change all your GetFieldSelections([Field]) to GetFieldSelections([Field],',',1000)

Ex. GetFieldSelections([Country]) to GetFieldSelections([Country],',',1000)

Regards,

Sokkorn

[sandeepprasad_j]

HI Sokkorn,

Even though i am giving this i am not getting the sheets more than 6 , so can u please help me in this

Sandeep.

[alexandros17 · Accepted solution]

=

if( Index(Concat( GetFieldSelections([Country],',',40),'|'),'US')>0 or Index(Concat(GetFieldSelections([Product],',',40),'|'),'US biscuit')>0,1,0

or Index(Concat(GetFieldSelections([US Product],',',40),'|'),'US biscuit')>0)

change this instruction in all the tabs ... and it will work