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: 
Anonymous
Not applicable

Lock dimensions from filter selection

I have created one pivot table and one pivot chart. Both have two same dimensions(Zone,Date)  but the table has one expression(Sum of Sales) where as the chart contains three expressions (Sum of Sales, 1st Quartile of Sales and 2nd Quartile of Sales) . Hence, In  chart we need to select Zone to analyse the data date wise. But, when I am selecting a Zone its showing the graph properly but the Pivot table is showing the data only for the selected zone. I want to show the data for all the zones in the pivot table i.e. Zone selection (filer) will not impact the table but Graph will show the data for the selected zone . Can any one help on this please.

7 Replies
sunny_talwar

Use this expression for your pivot table where you want to ignore selection in Zone field

Sum({<Zone>} Sales)

Anonymous
Not applicable
Author

It wont work, Because when I am clicking on any of the zone it showing only the selected zone as follows:

The table is as follows:

  Normal:

Zone2014201520162017
East224226228230
North251253255415
South216218220403
West419245247132

For example if I Select South Zone from the Zone filter. It is showing the table as follows:

 

Zone2014201520162017
South216218220403

My requirement is to display all the  zone along with its data irrespective of zone selection. Basically I want to lock the entire table from zone filter.

sunny_talwar

Even if you use this?

Sum({<Zone>} Sales)


That can't be true... can you share a sample where you see this behavior?

Mark_Little
Luminary
Luminary

Hi,

Would it not be

Sum({<Zone=>} Sales)

Mark

sunny_talwar

Same thing.... equal sign makes no difference

JustinDallas
Specialist III
Specialist III

I never knew that, thanks.

sunny_talwar

Its personal preference, some people like to use it, but I tend to avoid it because already the expressions are fairly convoluted and I try to remove anything extra that I can from my expressions