topic Re: Filter Pivot Table Based on Values Entered in Inputbox in QlikView

Filter Pivot Table Based on Values Entered in Inputbox

Mon, 11 Feb 2013 07:38:15 GMT

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 :

EmpID	Last Name	First Name	Title	Hire Date	Office	Extension	Reports To	Year Salary	Age	Experience
24	Crawford	Judy	Systems Manager	06/08/05	1	200	19	50400.00	45	20.7
1	Roll	Frank	Sales Representative	10/01/03	2	501	4	61000.00	35	10.3
2	Presley	Erik	President	09/14/03	1	101		180000.00	49	28.8
3	Carsson	Rob	Sales Representative	10/01/04	5	102	4	63000.00	27	4.8
9	Brolin	Helen	Sales Representative	02/15/07	1	103	4	60000.00	29	5.7
42	Ärlig	Östen	Account Manager	12/24/03	1	104	3	51000.00	26	3
52	Ashkenaz	Mike	Account Manager	11/30/04	1	-	42	49500.00	24	1.2
7	Lindwall	Tom	Sales Representative	02/22/07	2	201	4	61000.00	28	3.5
8	Shine	Leif	Sales Coordinator	03/05/04	2	202	2	65000.00	38	13

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.

Re: Filter Pivot Table Based on Values Entered in Inputbox

Anonymous — Mon, 11 Feb 2013 07:48:38 GMT

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

Re: Filter Pivot Table Based on Values Entered in Inputbox

Mon, 11 Feb 2013 09:02:00 GMT

Hi jonbroughavone ,

Can you please explain with any example ?

Thanks

Re: Filter Pivot Table Based on Values Entered in Inputbox

manideep78 — Mon, 11 Feb 2013 11:08:51 GMT

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

Re: Filter Pivot Table Based on Values Entered in Inputbox

Mon, 11 Feb 2013 11:39:57 GMT

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.

Re: Filter Pivot Table Based on Values Entered in Inputbox

manideep78 — Mon, 11 Feb 2013 12:46:10 GMT

Please find the enclosed file.

Thanks

Re: Filter Pivot Table Based on Values Entered in Inputbox

Tue, 12 Feb 2013 05:44:40 GMT

Hi Manideep,

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

Re: Filter Pivot Table Based on Values Entered in Inputbox

Tue, 12 Feb 2013 05:57:53 GMT

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.