Aggr & Always select one option in filterpane

[SatyaPaleti]

Hi Everyone,

We have a requirement. In the filter pane we need to show only accessible field values.

For Example I am having Country Field and we have 5 countries India, U.S.A, England, Australia, Canada

I can access only 3 countries i.e., India, USA & England. 

So in the filter I have to show only these 3 countries. So i am using following condition Aggr(Country,Country). I can see only accessible Countries

but we have a requirement of always select one option in this for this country field. At this position i can see only selected country and rest of the two countries are getting vanished. We need to see rest of 2 countries along with selected one.

Can anyone please help to resolve this Issue

Thanks,

Satya

[Digvijay_Singh]

Couldn't understand how Aggr(Country,Country) reduced 3 values from 5 in the filter pane, are you guys using section access?

[SatyaPaleti]

Hi @Digvijay_Singh 

Yes we are using section access

[Digvijay_Singh]

So that means if you just use country in the filter pane, it should show only 3 values I think, not able to understand why do you need to surround your country field with Aggr?

[Digvijay_Singh]

it appears that always one selected value doesn't work with calculated field (aggr makes it calculated field).

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/DataSource/select-si...

• The Always one selected value is not supported for derived fields.

[SatyaPaleti]

Hi Vijay,

In the filter we need to show only accessible values. For example I have an access to 3 countries among 5. We need to show only 3 values and one should be always select among those 3