Retain default view of the chart when toggling between tabs

[newqlik2017]

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.

[newqlik2017]

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.

[newqlik2017]

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

[adityaakshaya]

Hi Subash,

Yes, it can be done. You can use

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

Regards,

Akshaya