Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-04-09 07:34 AM

How can i make the sheet to show data greater than fy2016?

Hi,

I have some data for FY2011 to 2018.

And i have created a report on that.

And what i want now is in a particular sheet i want to show the results for data which is greater than FY2016.

How can i make the sheet to show data greater than fy2016.

i want this restriction to a particular sheet in a report??

342 Views
0 Likes
2 Replies
vishsaggi
Champion III
Champion III
‎2018-04-09 03:29 PM

Do you have a field that stores this FYYear? May be you want try on activate sheet trigger using sheet properties. Like

Change the Field name based on your originalfieldname.

Ctrl+Alt+S to open sheet properties and then set below

303 Views
0 Likes
Qrishna
Master
Master
‎2018-04-09 04:13 PM

Triggers hinders the performance, rather go with other approaches.I have shown you 2 different approaches in the attached file.

297561 - sheet to show data for a particular value.qvw
303 Views