topic Re: How to create a customize filter/selection/listbox in QlikView

How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 06:38:01 GMT

Hi guys,

i have created a pivot table. in my correctio column, actually consists of value C,D.

But my client wants to have a selection box which can give the client a choice of choosing view "C Only", "D Only", "C & D" , "All".

So, i do not know how to create this filter. I have tried to create in the script editor as such:

if(correctio_tip = 'c', 'C',

if(correction_tip='d','D',

if(correction_tip='c' or 'd', 'C & D')))

Help help help

Rgds

Jim

Re: How to create a customize filter/selection/listbox

Gysbert_Wassenaar — Thu, 11 Aug 2016 06:42:46 GMT

Create a listbox with correction_tip as field. Then let the client select only C or select only D or select C and D both or select nothing which means select all. It's standard functionality. No need to muck about trying to create something that already exists and works.

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 06:58:25 GMT

That i know, Gysbert. but i have situation as such that i have created a listbox using field correctio_tip. so this listbox there is "C" , "D".

So when i select/highlight "C" and "D" , it listed out all the Cs and Ds.

i wanted a list box when i select " C & D" then it will only show me customer ID - 80100317 with correctio_id of "C & D" only.

Rgds,

Jim

Re: How to create a customize filter/selection/listbox

Anonymous — Thu, 11 Aug 2016 07:08:21 GMT

Hi Jim,

Create a new field with C,D, C&D, All, with only one selection.

On field triggers, create a new action on your new field to select values on correctio_id:

IF(GetSelectedCount(NewField)=1 and (NewField='C' or NewField='D'), NewField,

If(GetSelectedCount(NewField) = 1 and NewField = 'C&D', '(C|D)', ''))

Regards!!

Re: How to create a customize filter/selection/listbox

Gysbert_Wassenaar — Thu, 11 Aug 2016 07:10:19 GMT

Ah, like that. Ok try creating a new table with a new field:

NewTable:

LOAD DISTINCT

cust_id,

correction_tip as Newfield

RESIDENT

ExistingTableWithCustIDAndCorrectionTip

;

CONCATENATE (NewTable)

LOAD

cust_id,

concat(correction_tip, ' & ', correction_tip) as Newfield

RESIDENT

ExistingTableWithCustIDAndCorrectionTip

GROUP BY

cust_id

;

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 07:14:56 GMT

let me try this bro.

let you know in a while.

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 07:28:09 GMT

Gysbert,

i have followed your steps, something is not right though... it gave me a long list - in a listbox. like this:

Rgds

Jim

Re: How to create a customize filter/selection/listbox

Gysbert_Wassenaar — Thu, 11 Aug 2016 07:31:24 GMT

Ah, yes of course. Try this for the second part:

CONCATENATE (NewTable)

LOAD

cust_id,

concat(NewField, ' & ', NewField) as Newfield

RESIDENT

NewTable

GROUP BY

cust_id

;

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 07:31:52 GMT

maybe u r rite... wait... maybe i need 1 more key.

Re: How to create a customize filter/selection/listbox

Thu, 11 Aug 2016 07:37:14 GMT

Hi Jim,

Try this expression. I hope it will works.

IF(GetSelectedCount(Correction)=1 and (Correction='C' or Correction='D'), Correction,

If(GetSelectedCount(Correction) = 1 and Correction= 'C&D', '(C|D)', '')).

Thanks,

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 07:41:48 GMT

Seems to working fine bro. but just to check with you, there's a "blank" in the list box, is it because of the data?

Rgds

Jim

Re: How to create a customize filter/selection/listbox

Gysbert_Wassenaar — Thu, 11 Aug 2016 07:44:11 GMT

Then somewhere in your data you have a record that contains a blank value in the correction_tip field.

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 08:15:50 GMT

Hi Manuel,

How to create this part ? "Create a new field with C,D, C&D, All, with only one selection."

I already have a correctio_id with data "C", "D".

Re: How to create a customize filter/selection/listbox

Anonymous — Thu, 11 Aug 2016 08:19:52 GMT

Hi Jim,

One InLine table. See attached file.

Regards!

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 08:24:36 GMT

something is not right. i have selected C&D, but it is still listing all .

Re: How to create a customize filter/selection/listbox

Gysbert_Wassenaar — Thu, 11 Aug 2016 08:30:19 GMT

Any customer that has both C and D will of course have C. How is that wrong?

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 08:34:54 GMT

hello Nanda,

where to add this expression?

Rgds

Jim

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 08:44:43 GMT

missed something seems Manuel,.

i have selected C&D , but it is still listing all the Csss and Dssss...

Re: How to create a customize filter/selection/listbox

Gysbert_Wassenaar — Thu, 11 Aug 2016 08:47:19 GMT

Then all these cust_id values have records with a C and records with a D.

Re: How to create a customize filter/selection/listbox

jim_chan — Thu, 11 Aug 2016 08:47:26 GMT

Hello Nanda,

what is between urs and Manuel?

Manuel

IF(GetSelectedCount(NewField)=1 and (NewField='C' or NewField='D'), NewField,

If(GetSelectedCount(NewField) = 1 and NewField = 'C&D', '(C|D)', ''))

Nanda

IF(GetSelectedCount(Correction)=1 and (Correction='C' or Correction='D'), Correction,

If(GetSelectedCount(Correction) = 1 and Correction= 'C&D', '(C|D)', ''))