topic Re: Multiple sheets visible as per the seelction? in QlikView

Multiple sheets visible as per the seelction?

Tue, 05 Feb 2013 09:50:49 GMT

Hi All,

I have a field(Property), as per the values i am creating number of sheets with same names.

Now i have done something like as per the no.of values seelction from the field,i am showing the corresponding sheets.But some problem is there.

For your reference,I am attaching a sample application.Please go through it and send your responses to make it correct.

Thanks in advance.

Regards

Kumar

Re: Multiple sheets visible as per the seelction?

Tue, 05 Feb 2013 11:20:52 GMT

Use the following conditional expression:

=SubStringCount(Concat('#' & Property & '#', '|'), '#Lux#')

Attached you also have the modified document.

Re: Multiple sheets visible as per the seelction?

Tue, 05 Feb 2013 12:36:50 GMT

Hi JG,

It is good but the default sheet should be "Main" when nothing was selected from "Property".

I have modified the condition like

=SubStringCount(Concat('#' & if(GetSelectedCount(Property)>0,Property & '#', '|')), '#Lux#')

Thanks a lot for the solution.

Juan Gerardo Cabeza wrote:
Use the following conditional expression:
=SubStringCount(Concat('#' & Property & '#', '|'), '#Lux#')
Attached you also have the modified document.
JG

Regards

Kumar

Re: Multiple sheets visible as per the seelction?

Thu, 07 Feb 2013 09:52:42 GMT

i have changed the way variable storing the values,

Hope the attached solution will work and help you.

Thanks & Regards,

Venakt T