topic Re: Filtered by Tab in QlikView

Filtered by Tab

Thu, 20 Mar 2014 17:52:20 GMT

I have a data file with data of 2012 and 2013, I want to have the 2012 data appear on a Tab called 2012 and the 2013 data on the Tab 2013, the third tab is called Dashboard and should have all data.

Is it possible to filter the data per Tab based on Expressions?

Re: Filtered by Tab

MK_QSL — Thu, 20 Mar 2014 17:55:14 GMT

Right Click on empty space of sheet

Properties

Triggers

OnActiveSheet

Add

Selection >> Select in Field

Field

Year

Search String

='2012'

OnLeaveSheet

Add

Selection >> Clear All

Do the same for 2013

Re: Filtered by Tab

Thu, 20 Mar 2014 17:58:04 GMT

if you mean tab is sheet. you can create text objects to navigate between sheet (using actions ex: activate sheet), you can add another action on the same text obj 'select in field' and give field name as year and value 2012, on the 2013 , you can have a action to clear the Year field and have select in field. and i prefer to avoid triggers when possible.

Re: Filtered by Tab

Thu, 20 Mar 2014 18:08:12 GMT

THANK YOU!

Works!

Re: Filtered by Tab

Anonymous — Thu, 20 Mar 2014 18:12:25 GMT

yes you can do that ... if you go to Sheet properties and then apply triggers as shown in the screen shots. And do the same in another sheet for year 2013. Hope this helps if it does not help post the qvw file we can help you with that

Re: Filtered by Tab

MK_QSL — Thu, 20 Mar 2014 18:31:04 GMT

Please close this thread by selecting correct answer...