topic Re: Clear functionality in QlikView

Clear functionality

Thu, 07 May 2015 20:34:10 GMT

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.

Re: Clear functionality

Anonymous — Thu, 07 May 2015 20:58:32 GMT

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, ',')&')')

Re: Clear functionality

Thu, 07 May 2015 21:14:33 GMT

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.

Brand	LinkedIn	Total
Company 1	-	40
Company 2		20
Company 3		5
Company 4		4

Re: Clear functionality

Anonymous — Thu, 07 May 2015 21:30:35 GMT

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.

Re: Clear functionality

ToniKautto — Thu, 07 May 2015 22:30:59 GMT

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.

Re: Clear functionality

Fri, 08 May 2015 13:28:17 GMT

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