Filter in one sheet and Display filtered data in another sheet

Q&A
,
1

hi all,

My use case is having alot many filters, i need 20 filter in the sheet, but the sheet is going way bottom of the screen, because of so many filters the data is not shown properly. Is there a way that i could show filter on one screen and filtered data on another screen…?

i checked Navigation action but thats only possible when sheet 1 has data and clicking on it sheet 2 opens, but my requirement is no data in sheet1, only data would be in sheet 2 and would depend on filters in sheet 1. Help is much apprieciated.
Thanks in advance.

2

Hi @suvarna0212

Welcome to the community!

You can have a sheet with just the parameter controls to make selections
image

You can then have another sheet with the visual(s) that reference the parameter values. See example below

image
image1537×154 18.1 KB

You don’t need Navigation action for this.

Regards,
Giri

3

but filtering in sheet1 can filter the data and show in sheet2 ..?

4

Also … my requirement is such.. that i need to filter and click apply on sheet1 and should be redirected to result in sheet2.. is this possible?

5

Hi @suvarna0212

If you want the user to click something and get them to navigate you need a visual and added a Navigation URL action on it.

You can probably add a KPI visual with a Navigate URL interactive action and provide the sheet where you want to navigate.

Regards,
Giri

6

hi.. i dont want want user to click something and navigate.. i need to filter from controls at top of the sheet(outside the sheet) and once filter is selected it should navigate to new sheet .. just on filter.. apply button click

7

Also, i have 20 filters.. if i show all the filters in Sheet1, my visual of table is going very much below.. .. thats why i need this functionality.. another question is can i have filters with OR condition instead of AND condition ?

8

Hello @suvarna0212, if you use parameters for your controls in the first sheet, you could then use those same parameters to filter your visuals on the 2nd sheet. You do not need to implement any kind of action to go to the next sheet either.

I built an example of this implementation in QuickSight Arena. You can check out the analysis here:
Filter in one sheet and Display filtered data in another sheet