topic Re: Always One selected value for two different sheets with different values in App Development

Always One selected value for two different sheets with different values

sagarkharpude — Thu, 28 Mar 2019 06:33:38 GMT

Hi All,

I have one filter, Region(with values like South & East) and three different sheets(South, East and All) in QlikSense.

So When I am on sheet 1, it should always select one value by default i.e. "South". It should be locked and not visible on the front end to the users.

When I am on sheet 2, it should always select another value by default i.e. "East". It should be locked and not visible on the front end.

When I am on Sheet 3, it should display all Regions and clear all the selection made in earlier sheets.

Could you please assist me on this.

Thanks,

Sagar Kharpude

Re: Always One selected value for two different sheets with different values

vikasmahajan — Mon, 25 Mar 2019 10:58:13 GMT

Hi ,

you can insert region={'South'} in set analysis for south tab , also the same region='East' for another tab. accordingly values will fetched in set analysis.

Vikas

Re: Always One selected value for two different sheets with different values

sagarkharpude — Tue, 26 Mar 2019 15:43:39 GMT

Hi Vikas,

Can we set the expression for tabs in Sense. Because I was checking the sheet properties. I don't see this option in sense. Can you please send me one sense sample file.

Re: Always One selected value for two different sheets with different values

vikasmahajan — Thu, 28 Mar 2019 08:11:21 GMT

PFA attached sample QVF.

Vikas

Re: Always One selected value for two different sheets with different values

sagarkharpude — Thu, 28 Mar 2019 08:36:51 GMT

Hi Vikas,

Thanks for sharing the file. But actually this is not the solution what I am looking for.
I have many objects on sheet like Filters, charts, text objects, etc. I can't put this expression in each chart objects.
Better way is to apply one trigger(Regions='East' or 'South') like Qlikview. Clear the value of trigger and change it according to next/previous sheet. But I am not sure if we can set some triggers in sense.

Re: Always One selected value for two different sheets with different values

vikasmahajan — Thu, 28 Mar 2019 09:54:22 GMT

use can use apply selections extension available in Qlik Branch / Garden. Use need to create a bookmark and then you can use this extension on every page with diff selections. Please find attached sample.

Vikas

Re: Always One selected value for two different sheets with different values

vikasmahajan — Thu, 28 Mar 2019 09:55:26 GMT

use this extension

Re: Always One selected value for two different sheets with different values

sagarkharpude — Mon, 01 Apr 2019 06:51:14 GMT

Hi Vikas,
Thanks for sharing the app. I appreciate your help.
I have installed this extension and created bookmark. It's work fine when we navigate to different sheets. Only one problem is, we can't lock the selections.

Thanks,
Sagar Kharpude