topic Re: Input Box using Inline Tables in QlikView

Input Box using Inline Tables

Wed, 03 Aug 2011 20:14:57 GMT

Hi all,

In my Qlikview Application I'm using input boxes for dropdown navigation that's present on every sheet in the application. All the sheets are correctly displayed in the input box dropdown, but when I choose one of the options, they're taking me to the wrong sheet. I double checked to make sure the Sheet IDs are correct and they are.

In Input Box Properties -> Constraints I have the Listed Values checked and used this as my expression:

=concat([SalesSheets], ',')

My inline table below

SalesSheets:

LOAD * INLINE [

SalesSheets, SheetID1

1.Option 1, SH24

2.Option 2, SH09

3.Option 3, SH14

4.Option 4, SH17

5.Option 5, SH25

6.Option 6, SH05

7.Option 7, SH54

8.Option 8, SH55

];

Does anyone know how this can be fixed? Any help would be greatly appreciated!

Thanks!

Sean

Input Box using Inline Tables

Thu, 04 Aug 2011 00:24:09 GMT

Hi sean ,

Correct me if i got it in a wrong way ,

you are trying to toogle between your sheets by using a input box .

Can you try that in this way like in sheet properties ---> show sheet ---> use condition $(vShowsheet) =1 for SH24 &

$(vShowsheet) =2 for SH19 ..............$(vShowsheet) =8 for SH55 .

Now declare a run time variable vShowsheet =0

Now use input box on this variable to toogle from sheet1 to sheet8 .

If it's not working let me know i'll try to give you another solution

thanks

Meher

Re: Input Box using Inline Tables

Thu, 04 Aug 2011 00:31:03 GMT

Sean

Try to see the attached qvw

thanks

Meher

Re: Input Box using Inline Tables

Thu, 04 Aug 2011 03:38:53 GMT

Hi,

Instead you can just try as per the attached.

Cheers.

Re: Input Box using Inline Tables

Tue, 09 Aug 2011 20:40:14 GMT

Hi Merwan,

Your solution is definitely another way to do it, but I would like to have this working as a dropdown or something similiar where the user won't need to input a value in to allow them to navigate from sheet to sheet.

If you have any other solutions that could acheive this, I am more than willing to give them a try!

Thanks,

Sean

Re: Input Box using Inline Tables

Tue, 09 Aug 2011 20:41:33 GMT

Hi BlackRockS,

Is it possible once an option is selected in the multibox, I could have it go to that sheet? All the multibox is doing is selected the option, it's not actually performing any action which is what I need it to do.

Thanks again for all the help!

Sean

Re: Input Box using Inline Tables

Tue, 09 Aug 2011 22:42:26 GMT

Hi Sean,

try this attached qvw

if u want to toggle by a specifier let me know i'll try it ...

Thanks

Meher

Re: Input Box using Inline Tables

Tue, 09 Aug 2011 22:45:00 GMT

Sean , u can use ur sheet ID instead of sheetno. in my inline

thanks

Meher

Re: Input Box using Inline Tables

Wed, 10 Aug 2011 16:08:32 GMT

This is definitely another possibilty, but is it possible to do this with an input box? I'm creating multiple inline tables (3 of them) because the application contains 30+ sheets. This application is broken up into 3 categories where I'll be using 1 of the 3 inline tables as the navigation. I want to use a drop-down menu to navigate if possible, but if it isn't possible to acheive this currently, I will try another option.

Thanks!

Sean

Re: Input Box using Inline Tables

rwunderlich — Wed, 10 Aug 2011 17:09:07 GMT

You didn't say how you were making the switch, I assume with a trigger on the variable?

Attached is an example using an input box dropdown and an Activate Sheet action. You can hide the tabrow in document settings if you want to make the dropdown the only sheet navigation option.

-Rob

http://robwunderlich.com

Input Box using Inline Tables

Thu, 11 Aug 2011 00:07:32 GMT

Hi Sean ,

Can you clarify me onething ,

do u want to navigate between 30 sheets or 1 of 3 segments ?

if it is one do your dropdown has to be visible upto your segment or 30+ sheets at once or by segments ?

thanks

Meher

Re: Input Box using Inline Tables

Thu, 11 Aug 2011 01:39:34 GMT

Hi,

Actually when you select it is moving to another sheet based on the multibox selection but there were no objects in the sheet you were not able to identify the same.

Now i added some text objects in each sheet so you can see you are navingating to different sheets.

To see all the available sheets in the app go to Menu - Settings -> Document Properties - > Sheets tab.

Please see the attached sample.

Cheers.