Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Filter Pivot Table Based on Values Entered in Inputbox

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.

7 Replies
jonbrough
Valued Contributor

Re: Filter Pivot Table Based on Values Entered in Inputbox

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

Re: Filter Pivot Table Based on Values Entered in Inputbox

Hi jonbroughavone ,

Can you please explain with any example ?

Thanks


manideep78
Valued Contributor

Re: Filter Pivot Table Based on Values Entered in Inputbox

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

Re: Filter Pivot Table Based on Values Entered in Inputbox

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
Valued Contributor

Re: Filter Pivot Table Based on Values Entered in Inputbox

Please find the enclosed file.

Thanks

Not applicable

Re: Filter Pivot Table Based on Values Entered in Inputbox

Hi Manideep,

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

Not applicable

Re: Filter Pivot Table Based on Values Entered in Inputbox

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.

Community Browser