Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Clear functionality

Hi All,

How to implement clear functionality of qlikview for one of the value in the list box drop down??

In the listbox,I have company1,Company2 and All so.on.If user select "All" Clear functionality should be implemented.

Tags (1)
5 Replies
Highlighted
kvijayab
New Contributor III

Re: Clear functionality

Document Properties

Triggers

Field Event Trigger

Select in Field Action

if company is your field then

=if(Match(concat(DISTINCT company, ','), 'All'), '*', '('&concat(DISTINCT company, ',')&')')


Highlighted
Not applicable

Re: Clear functionality

Hi Vijay,

Sorry,I don't have "All" value in listbox and don't have "All" value in the data as well.

Req: We can display ALL in Listbox and user selects ALL clear functionality should be implemented.

BrandLinkedInTotal
Company 1-40
Company 220
Company 35
Company 44
Highlighted
kvijayab
New Contributor III

Re: Clear functionality

Keep a button or a text object with an action to clear the field. You can make it look like an "All" by placing the object appropriately.

Highlighted
Employee
Employee

Re: Clear functionality

I understand what you are trying to do, but my take on this is that it is a bad idea. The concept of QlikView is to make selections and make results based on your selections. Introducing a non-existing value that does not associate properly with your data will not give the end-user a good interface.

My suggestion is that you look into using the sheet object's Special Icons instead. For example you can add a Clear icon in a list box. See Object Properties > Caption for available icons.

2015-05-08 08_28_27-QlikView x64 - [C__Users_tko_Documents__slask_Reload_QQ.qvw_].png

Highlighted
Not applicable

Re: Clear functionality

Thanks for your quick reply Toni.I will try and let you know how it works.