Multiselect and single select on same field in qlik sense

[Qlik1_User1]

Hi All,

Need help on below.

Can we have a multi-select and Always one selected on same field (Month).

Or

Can we have a multi-select and Always one selected on different field (Month, Month_new) but having same data .

[Chirag2397]

It can be done by loading month and Month_New, in which for month you can select Always one selected and for Month_New there can be more than 1 selections at the same time. Can you please share more details like which chart or what you are trying to do, so that it will be more clear and easier to answer it.

[Qlik1_User1]

Hi Chirag,

I have already tried this but this is not working

LOAD
Name,
"Age",
"Month",
"Month" as Month_new,
Salary
FROM [lib://Data/Single Select.xlsx]
(ooxml, embedded labels, table is Sheet1);

Charts i am using on sheet 1

Filterpane with Dim- Month

Tablebox with all the fields

Charts i am using on sheet 2

Filterpane with Dim- Month_new

Tablebox with all the fields

Data is attached

[Chirag2397]

Hi,

According to my knowledge this can't be done but i have one more option, maybe this will help you.

In table ->

1. Go to Add-ons -> Data handling 

2. Calculation Condition -> GetSelectedCount(Month)>0

    Displayed message -> 'Please select attleast one states'.

[Qlik1_User1]

@Chirag2397 Thanks for suggestion but that won't fulfil the requirement.

Can we do something in filterpane If nothing is selected or more than 1 value selected in Month than MAX(Month),else all Months

Tried these options

1. IF(GetSelectedCount(Month)>1,MAX(Month),Month) -- its not working

2. IF(GetSelectedCount(Month)>1,vMaxmonth,Month) -- it's working when selecting only 1 value but when selecting more than 1 values its not working.

vMaxmonth - ONLY({1<Month={$(=Max({1}Month))}>}Month)