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

Filter Pivot Table Based on Values Entered in Inputbox

Dear All,

I have one pivot table which should be filter based on values entered in Inputbox.

Below is one sample Table I have taken from which Pivot Table is created.

Snapshot of Excel :

EmpIDLast NameFirst NameTitleHire DateOfficeExtensionReports ToYear SalaryAgeExperience
24CrawfordJudySystems Manager06/08/0512001950400.004520.7
1RollFrankSales Representative10/01/032501461000.003510.3
2PresleyErikPresident09/14/031101
180000.004928.8
3CarssonRobSales Representative10/01/045102463000.00274.8
9BrolinHelenSales Representative02/15/071103460000.00295.7
42ÄrligÖstenAccount Manager12/24/031104351000.00263
52AshkenazMikeAccount Manager11/30/041-4249500.00241.2
7LindwallTomSales Representative02/22/072201461000.00283.5
8ShineLeifSales Coordinator03/05/042202265000.003813

Snapshot of Pivot Table :

Now when user wants to filter data where Annual Salary is between 45000 - 50000 then I have provided two input boxes where user will enter

Salary = 50000 with tolerance 5000 ( this provision is as per client's requirement).

Similar provision is needed for filtering data further on Age & Experience basis.

So how can I do this? Can anybody help me in getting this ?

Thanks

PS : I have attached QVW as well as Data source for your reference.

1 Solution

Accepted Solutions
Not applicable
Author

Hi All,

One of my collegue gave the solution & its working as per the requirement.

Thanks all for valueable efforts.

Please find attached qvw file for correct solution.

View solution in original post

7 Replies
Anonymous
Not applicable
Author

Your attached application seems to do what you want it to. Currently it seems to display the rows if at least one of the conditions is meet. If you want it to reduce based on all of the conditions you will need to include all three tests them all three expressions. You should be able to reference Column(ColumnNo) though when doing this.

Jonathan

Not applicable
Author

Hi jonbroughavone ,

Can you please explain with any example ?

Thanks


manideep78
Partner - Specialist
Partner - Specialist

Hi Kiran,

I have done this with the help of a button object.Please checkout the attached qvw file and let me know whether it satisfied your requirement or not.

Thanks,

Manideep

Not applicable
Author

Hi  Manideep,

Appreciate your work.

You have used button to filter out table but what if user wants to see all the data?

,what I needed is ,after entering values in all the input boxes,only related data should be displayed.


Thanks.

manideep78
Partner - Specialist
Partner - Specialist

Please find the enclosed file.

Thanks

Not applicable
Author

Hi Manideep,

Thanks for reply.But I am looking for something else.

Not applicable
Author

Hi All,

One of my collegue gave the solution & its working as per the requirement.

Thanks all for valueable efforts.

Please find attached qvw file for correct solution.