topic Re: Check box to exclude value in QlikView

Check box to exclude value

richard_chilvers — Tue, 12 Apr 2016 12:40:35 GMT

In my table every record has a value in REC_TYPE of A, B, C, D.

In my dashboard, I want to always show records with values in REC_TYPE of A and B, and also default to include values of C and D.

But I want 2 check boxes:

Click Here to EXCLUDE REC_TYPE of C [ ]

Click Here to EXCLUDE REC_TYPE of D [ ]

Please advise a neat way to do this, or point me to the correct place on this forum.

Thanks

Re: Check box to exclude value

prashantbaste — Tue, 12 Apr 2016 13:19:38 GMT

Hi Richard,

One way to implement your requirement is as -

Create a Inline field with REC_TYPE with values A,B,C,D as -

REC_TYPE:

LOAD * INLINE [

RecType

];

and then in front end use this RecType into list-box for selection which fields to select. (Here I have considered all 4 types; you can take only specific values that you want to allow for selections like C & D only)

Then where ever your are going to use your (in Dimensions/Expressions) you can write condition to comparing with selected values of RecType.

For more understanding please find attached sample.

Hope this is useful for you. Feel free to ask further.

Regards,

Prashant P Baste

Re: Check box to exclude value

richard_chilvers — Tue, 12 Apr 2016 15:17:25 GMT

Thanks for your helpful reply.

I am hoping to allow users to make a selection to reduce the amount of data presented so that I can avoid having conditional dimensions or expressions.

I believe QlikSense has a Search Exclude feature. This is what I need in my trigger action.

Re: Check box to exclude value

swuehl — Tue, 12 Apr 2016 15:28:47 GMT

Maybe like attached, using a trigger action to filter your Types.

Re: Check box to exclude value

richard_chilvers — Tue, 12 Apr 2016 15:38:46 GMT

Thanks - that's the kind of thing .... but could you explain how it works ?

I don't understand how the List Box called Exclude Type is able to EXCLUDE values instead of INCLUDing them ?

Regards

Re: Check box to exclude value

swuehl — Tue, 12 Apr 2016 15:43:43 GMT

Richard,

I just reused the previous sample with some modifications, so the list box is using the field Rec_Type, a data island. Now check Settings - Document properties - Triggers for the trigger and action set on this field.

Re: Check box to exclude value

richard_chilvers — Tue, 12 Apr 2016 15:51:36 GMT

Ah yes - sorry I missed the trigger on the field !

Re: Check box to exclude value

swuehl — Tue, 12 Apr 2016 16:05:49 GMT

So that's not what you were looking for?

Re: Check box to exclude value

richard_chilvers — Tue, 12 Apr 2016 16:10:06 GMT

Its helpful but rather too complicated for what I need to achieve.

I like to keep my models simple to ensure they can be easily supported.

Rgds

Re: Check box to exclude value

swuehl — Tue, 12 Apr 2016 16:14:57 GMT

So what could be more simple than a single trigger / action? Maybe just the list box with the Type values?

Re: Check box to exclude value

richard_chilvers — Wed, 13 Apr 2016 07:38:13 GMT

I'm always conscious of supporting apps and deciding whether a development investment is worth the value it gives the end user. For my organisation it would be difficult for us to support/justify a complex formula such as this:

='=Sum({1<Type -= {$(=GetFieldSelections(RecType, chr(44)))} >} 1)'

I'm sure many developers for other organisations do this and more complicated apps.

But thanks for your help.

Re: Check box to exclude value

vikasmahajan — Wed, 13 Apr 2016 08:57:27 GMT

cool

Vikas