Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

richard_chilvers
Contributor III

Check box to exclude value

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

1 Solution

Accepted Solutions
prashantbaste
Contributor II

Re: Check box to exclude value

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

    A

    B

    C

    D

];

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

11 Replies
prashantbaste
Contributor II

Re: Check box to exclude value

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

    A

    B

    C

    D

];

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

richard_chilvers
Contributor III

Re: Check box to exclude value

Hi

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.

MVP
MVP

Re: Check box to exclude value

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

richard_chilvers
Contributor III

Re: Check box to exclude value

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

MVP
MVP

Re: Check box to exclude value

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.

richard_chilvers
Contributor III

Re: Check box to exclude value

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

MVP
MVP

Re: Check box to exclude value

So that's not what you were looking for?

richard_chilvers
Contributor III

Re: Check box to exclude value

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

MVP
MVP

Re: Check box to exclude value

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

Community Browser