topic Retain default view of the chart when toggling between tabs in QlikView

Retain default view of the chart when toggling between tabs

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a qvw with two tabs - Main 1 and Main 2.

1) Clicking on a button on Main 1 tab launches Main 2 tab
2) The default view of the chart on Main 2 tab should always be a specified one - in this case Unit & Amount.

When on Main 2 tab, if you cycle thru different dimension - such as State or Status then go back to Main 1 tab and again go to Main 2 tab, it doesn't retain the (default) Unit & Amount view of the chart. Suggestions, please? A sample QVW is attached for your reference.

Thank you.

Re: Retain default view of the chart when toggling between tabs

Digvijay_Singh — Wed, 21 Feb 2018 20:25:20 GMT

Don't have license to access qvw but I think you would need Sheet trigger to apply bookmark which has your default view, may be -

Re: Retain default view of the chart when toggling between tabs

isingh30 — Wed, 21 Feb 2018 20:32:59 GMT

Please check this.

I can't understand part 2. What exactly you need in 2?

Thanks.

Re: Retain default view of the chart when toggling between tabs

newqlik2017 — Wed, 21 Feb 2018 20:47:12 GMT

On Main 2 tab, the default view of the chart should always be with Unit & Amount. If you click on cyclic drill down on Main 2 and let's say the chart view is now either (1) Status & Amount or (2) State & Amount and when you go back to Main 1 tab, and go back to Main 2 again, you'll see whatever chart view you left off on Main 2 but not the default chart view (Unit & Amount).

Re: Retain default view of the chart when toggling between tabs

isingh30 — Wed, 21 Feb 2018 20:54:59 GMT

Please check now. Let me know.

Thanks.

Re: Retain default view of the chart when toggling between tabs

newqlik2017 — Wed, 21 Feb 2018 20:59:25 GMT

That didn't work. I don't see any difference between the button you created and the one I had. This action simply launches Main 2 tab but how does it know to retain the default chart view?

Re: Retain default view of the chart when toggling between tabs

newqlik2017 — Wed, 21 Feb 2018 21:00:10 GMT

I created a bookmark and added to action to the button on Main 1 tab but that didn't seem to work.

Re: Retain default view of the chart when toggling between tabs

shilpan — Wed, 21 Feb 2018 21:08:03 GMT

Consider using Alternate States or you can detach the chart

Re: Retain default view of the chart when toggling between tabs

shilpan — Wed, 21 Feb 2018 21:24:23 GMT

See the attached app.

Re: Retain default view of the chart when toggling between tabs

adityaakshaya — Wed, 21 Feb 2018 22:22:38 GMT

Hi Subash,

As per my understanding, it is not feasible in Qlikview. But to meet your requirement, I have a workaround for you.

May be this can help you to achieve what you are looking for.

Regards

Re: Retain default view of the chart when toggling between tabs

newqlik2017 — Thu, 22 Feb 2018 13:51:29 GMT

Hi Akshaya,

The work around you have is a good alternate solution. Is it possible to show only selected column names in the $Field list box instead of displaying all columns? For instance, display only 2 fields (Unit and State) from the below list instead of all 4 fields. This is because I have more than 40 columns in my table.

Re: Retain default view of the chart when toggling between tabs

newqlik2017 — Thu, 22 Feb 2018 16:16:33 GMT

Never mind, the with match() function the later part of my question works.

Re: Retain default view of the chart when toggling between tabs

adityaakshaya — Thu, 22 Feb 2018 16:21:14 GMT

Hi Subash,

Yes, it can be done. You can use

=if(match($Field,'Unit','State')>0,$Field) in your listbox Field expression.

Regards,

Akshaya