Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtered by Tab

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?

5 Replies
MK_QSL
MVP
MVP

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

Not applicable
Author

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.

Not applicable
Author

THANK YOU!

Works!

Anonymous
Not applicable
Author

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

MK_QSL
MVP
MVP

Please close this thread by selecting correct answer...