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 in Pivot

I have created Pivot table in QlikView, but I can't add filter in Pivot table similar to excel pivots.

In excel 2007 we can add "Report filter" for any given field to ensure Pivot chart/table will display only selected values in report filter.

For e.g. if fruit_name is one of the column then in excel 2007 pivot we can select one or two types (for e.g. apples,oranges) and report will be always displayed for these two fruit names.

How to do this in Qlikview Pivot?

1 Solution

Accepted Solutions
edg_baltazar
Partner - Creator
Partner - Creator

Hello AdrePeter as i see it you have 3 options:

1. Create a listbox with the field you want to filter values... in this case a listbox of ´fruit_name´ and select only the values you want to see. (Obviosly this selection affects entire model).

2.Use a set analysis expression (Check the expressions tab of the object 'Option 2' in the .qvw that i made for you)

3.Use a calculated dimension to limit the values that you want to display in your chart (Check the dimensions tab in the object titulated Option 3 in the .qvw that i attach here)

Notice that if you use a calculated dimension in your case you dont have to use a set analysis in your expression (Check both , dimension and expression tab in the two objects that would be more clear)

Hope this help, Regards

View solution in original post

5 Replies
edg_baltazar
Partner - Creator
Partner - Creator

Hello AdrePeter as i see it you have 3 options:

1. Create a listbox with the field you want to filter values... in this case a listbox of ´fruit_name´ and select only the values you want to see. (Obviosly this selection affects entire model).

2.Use a set analysis expression (Check the expressions tab of the object 'Option 2' in the .qvw that i made for you)

3.Use a calculated dimension to limit the values that you want to display in your chart (Check the dimensions tab in the object titulated Option 3 in the .qvw that i attach here)

Notice that if you use a calculated dimension in your case you dont have to use a set analysis in your expression (Check both , dimension and expression tab in the two objects that would be more clear)

Hope this help, Regards

Not applicable
Author

Thanks Edgar. Listbox options I don't want to use as I want to put filter in Pivot itself. Thanks for providing options 2 and 3, I will try those.

Not applicable
Author

Try Property -> Presentation -> Enable Dropdown Select on dimension you want.

Thanks,

Max.

Not applicable
Author

Hi Max, thanks for the response. It was helpful. But I used "Set Analysis Expression" as it was helpful to my requirment.

Anonymous
Not applicable
Author

Hello!  I have a similar problem but want to filter the current week and onwards..  For example,  for this week , my first column would start with 02/03...

                            Monweek 02/03             02/10             02/17

           Product A                  100               200                300

Next week :

                                             02/10             02/17            02/27

           Product A                  100                  100                  100 

Tks.