How to make filter pane static for a field?

Anonymous — Wed, 14 Feb 2018 19:53:44 GMT

I have two tables Tab A and Tab B.

Tab A:

Load

Version,

Business,

Type,

from Highest

Tab B:

Load

Bu as Business,

Li as Type,

Purchase

from Purchase

So Tab A and B has Business and Type field common. But Tab B has more records in the field Business and Type.

I have created a visualization

Business

Type

Sum(Purchased)

Count(ID)

I have a filter pane to Select Version, because I want to select different Version for Count(ID) field, but I want to keep Sum(Purchase) static (it should not change with selection of Version).

But the problem is when I select Version from the filter pane, only matching rows from both the tables are showing up. Some records which are not there in Tab A are getting dropped.

I want only Count(ID) field should change on selecting Version and Sum(Purchase) should remain constant.

Please help experts. I will really appreciate any suggestion.

Thanks!

Re: How to make filter pane static for a field?

settu_periasamy — Wed, 14 Feb 2018 21:07:48 GMT

maybe try like

Sum({1}Purchase)

Re: How to make filter pane static for a field?

Digvijay_Singh — Wed, 14 Feb 2018 21:53:37 GMT

May be -

Sum({<Version=>}Purchase)

Re: How to make filter pane static for a field?

Anonymous — Mon, 19 Feb 2018 18:29:48 GMT

It worked . Thank you so much.

topic How to make filter pane static for a field? in QlikView

How to make filter pane static for a field?

Re: How to make filter pane static for a field?

Re: How to make filter pane static for a field?

Re: How to make filter pane static for a field?