Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

das_sujoy83
New Contributor

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

Re: Lock dimensions from filter selection

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

Sum({<Zone>} Sales)

das_sujoy83
New Contributor

Re: Lock dimensions from filter selection

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.

Re: Lock dimensions from filter selection

Even if you use this?

Sum({<Zone>} Sales)


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

mark6505
Valued Contributor III

Re: Lock dimensions from filter selection

Hi,

Would it not be

Sum({<Zone=>} Sales)

Mark

Re: Lock dimensions from filter selection

Same thing.... equal sign makes no difference

JustinDallas
Valued Contributor II

Re: Lock dimensions from filter selection

I never knew that, thanks.

Re: Lock dimensions from filter selection

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

Community Browser