Multiple field values as default selection

[shovongoutam]

In my App, I want to have either 'A' or 'B' and 'Def. 'of Dim1 always selected. So 2 selections by deafault and fixed. User wont be able to deselect . User can only select 'A'or 'B', While 'Def.' will be always selected.

Dim1

A

B

Def.

How can I achieve that?

I am using Qlik Sense Cloud.

Thank you in advance.

[Don_Stocks_]

The best solution here may be to create two new fields in your data, which will allow you to have the values always selected as you described. 

Load
...
Dim1  as Dim1
If(Match(Dim1, 'A','B'), Dim1, null()) as A_B_Selection,
If(Match(Dim1, 'Def.'), Dim1, null())  as Def_Selection
...
From...

Then you can set both of these new fields to have always one value selected. 

[shovongoutam]

Thanks. thats a nice trick. That should solve my issue

Although I was hoping to find some neat solution such as Filter settings.

Beacause, I have to do it for 3 more dimensions. And my qvd file is already ~500MB. Adding 3 more field will increase the size.

I will wait a bit for other solution, if any. If not I will have to follow your method. Will then accept solution.

Thank you.   

[shovongoutam]

Hi Don Stocks,

I tried to implement it. But there is an issue.

For instance, If I select A or B from A_B Selection, I cant select anything from Def_Selection. Because the A_B filter out the entry of Def.

Am I doing something wrong here?

Regards

SG

[Don_Stocks_]

I see. You could create an association in the data load to accomplish your goal. Change the second field load to:

If(Match(Dim1, 'Def.', 'A', 'B'), Dim1, null())  as DefAB_Selection