Creating a link to another tab and values to filters the Chart

[jimmygohhanjie]

Hi all,

in the ASP / HTML situation, link like chart.asp?year=2018 & Month=April& Department=Sale & Saleperson=Saleman1

can qlikview button does it too? a button in 'Intro' tablink to 'Analysis' tab with parameters pass in.

Thanks in advance.

Jimmy

[boorgura]

If it is a tab within the same QVW, then

Have an layout action - to activate and sheet,

and then have the "Select in Field" actions depending on your necessity.

[jimmygohhanjie]

Hi,

I am still new to Qilkview.

Is the screen shot what you meant?

have the 2 kind of action Under Action

[shiveshsingh]

can you share your app??

regarding the shared screenshot, if you click on activate sheet, then you need to put the sheet ID.So whenever you click on the button, it will navigate you to that sheet id,.

And if you want to select some fields, put that field name in field tab and the value that you want to select in search String tab,

[crusader_ · Accepted solution]

Hi,

Yes, this is the right place.

You can add several "Select in Field" actions, so hart.asp?year=2018 & Month=April& Department=Sale & Saleperson=Saleman1 wil be transferred as

Action                         Value

Activate Sheet                Document\SH01               <!-- sheet id you can find in Sheet properties <Ctrl>+<Alt>+<S>  -->

Select in Field               year     2018

Select in Field               Month     April

Select in Field               Department     Sale

Select in Field               Saleperson     Saleman1

Make sure you're selecting something which exists in your datamodel.

Good luck.

//Andrei

[jimmygohhanjie]

Thanks,

that is good guide.

I am not able to share the app as it is.

will need to create demo in later date.

[jimmygohhanjie]

Thank you.

this is very good guide.

will try it out later