topic Re: Can List Box display lists be controlled in QlikView

Can List Box display lists be controlled

bimala0507 — Mon, 09 Feb 2015 10:19:30 GMT

Dear experts:

Is there a way, I can control the list of values in list box.

E.g: I have a list of Item1.... Item10 values against a dimension and based on certain condition I would like to show only 5. Can it be achievable ?

Kind Regards,

Bimala

Re: Can List Box display lists be controlled

alexandros17 — Mon, 09 Feb 2015 10:21:46 GMT

At the end of list of fields there is an item "Expression", write there the condition to show items, ex.: If(myCond, myField, Null())

let me know

Re: Can List Box display lists be controlled

tresB — Mon, 09 Feb 2015 10:23:03 GMT

Expression like:

If(Field='Value1' or Field= 'Value2', Field)

Or,

If(Match(Field,'Value1' , 'Value2'), Field)

Re: Can List Box display lists be controlled

bimala0507 — Mon, 09 Feb 2015 10:25:34 GMT

Hi:

I tried that. It just shows the expression value as null() against the item, but I want the list item should be excluded if the condition satisfies.

Kind Regards,

Bimala

Re: Can List Box display lists be controlled

tresB — Mon, 09 Feb 2015 10:27:43 GMT

Just an extra Not would do the job. Try like:

If( Not myCond, myField)

Re: Can List Box display lists be controlled

bimala0507 — Mon, 09 Feb 2015 10:29:00 GMT

Hi:

Appreciate, if an example can be given.

Kind Regards,

Bimala

Re: Can List Box display lists be controlled

arulsettu — Mon, 09 Feb 2015 10:31:34 GMT

try this in list box expression

field - your field

if(match(field,'1','2','3','4','5'),field)

Re: Can List Box display lists be controlled

tresB — Mon, 09 Feb 2015 10:33:42 GMT

I am in hunt of appreciations. . PFA

Re: Can List Box display lists be controlled

bimala0507 — Tue, 10 Feb 2015 02:20:11 GMT

Hi Tresesco:

Thank you so much for your assistance. But my requirement is little different. I want to control the display of field1, by checking the field2 .

E.g. field1 field 2

'xxxx' 1

'yyyy' 1

'zzzz' 0

I would like to give a condition that if (field2=1) , than display all those field1 which satisfies the condition.

Attached the qvw file for your reference.

Kind Regards,

Bimala

Re: Can List Box display lists be controlled

anbu1984 — Tue, 10 Feb 2015 02:34:56 GMT

Try this expression

=If([field2]=1,field1)

Re: Can List Box display lists be controlled

PrashantSangle — Tue, 10 Feb 2015 04:14:59 GMT

Hi,

Use

Aggr(Field2,field1)

Regards

Re: Can List Box display lists be controlled

bimala0507 — Tue, 10 Feb 2015 04:46:16 GMT

Hi:

I tried the aggregate functions , but not getting the required result.

Kind Regards,

Bimala

Re: Can List Box display lists be controlled

anbu1984 — Tue, 10 Feb 2015 04:49:52 GMT

Check this

=If([field 2]=1,field1)

Re: Can List Box display lists be controlled

bimala0507 — Tue, 10 Feb 2015 06:42:57 GMT

Hi:

I checked, it is working fine. But in my case it just greys out, the values and still shows. Is it because I am using Cross Table. Appreciate, if you can check my app attached and replicate the same. I want to show only those dimensions which has Show_flag as 1 and hide rest for each report selected. Appreciate a quick help.

Kind Regards,

Bimala

Re: Can List Box display lists be controlled

anbu1984 — Tue, 10 Feb 2015 07:27:00 GMT

I am using PE. I did binary load of your data and created List box. Check the settings of list box in attached app with yours. You can also copy this list box and paste in your app