Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Karim_Khan
Creator III
Creator III

Atleast show one value when clear filter applied

Hi Team,

 

I am working on one of the requirement where we want to show atleast one value should be selected by default and we can have option to select as many fields from list box.

But when we apply clear option then atleast one value should be selected in list box and rest can be cleared.

 

I tried Always select one value option but it will not allow to select more than one fields due to its functionality.

I know it's achievable in qlikview through triggers but its not working in QlikSense.Any suggestion appreciated here.

We tried with Select field variable in Qlikview but no luck with Qliksense

Expression : =If(GetSelectedCount(LIST)=0,MaxString({$1}LIST),'('&Concat(LIST,'|')&')')

 

KK
2 Replies
robert_mika
Master III
Master III

I do not think you an do match at this point but at least you can request that vie

https://ideation.qlik.com

Chanty4u
MVP
MVP

Try this 

=If(GetSelectedCount(LIST)=0, MaxString(LIST), Concat(DISTINCT LIST, '|'))

Or

Action 1 → Clear All

Action 2 → Select in Field → LIST → value = =MaxString(LIST)