topic Re: Need All sheets to be displayed upon selections??? in QlikView

Need All sheets to be displayed upon selections???

sandeepprasad_j — Tue, 04 Jun 2013 08:45:21 GMT

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.

Re: Need All sheets to be displayed upon selections???

prasad_dumbre — Tue, 04 Jun 2013 08:55:05 GMT

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 )

Re: Need All sheets to be displayed upon selections???

alexandros17 — Tue, 04 Jun 2013 08:59:54 GMT

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

Re: Need All sheets to be displayed upon selections???

sandeepprasad_j — Tue, 04 Jun 2013 09:03:08 GMT

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

Thanks a ton in advance

Sandeep

Re: Need All sheets to be displayed upon selections???

sandeepprasad_j — Tue, 04 Jun 2013 09:03:29 GMT

HI Alexandros,

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

Thanks a ton in advance

Sandeep

Re: Need All sheets to be displayed upon selections???

Sokkorn — Tue, 04 Jun 2013 09:15:07 GMT

Hi Sandeep,

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

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

Regards,

Sokkorn

Re: Need All sheets to be displayed upon selections???

sandeepprasad_j — Tue, 04 Jun 2013 09:36:32 GMT

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.

Re: Need All sheets to be displayed upon selections???

alexandros17 — Tue, 04 Jun 2013 10:46:59 GMT

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