topic Expression in List Box in QlikView

Expression in List Box

krishna20 — Fri, 09 Jan 2015 08:10:07 GMT

Hi Friends,

I'm having field TP_YN. It is a flag . By using conditional expression i need to show Individual , Fleet, Both in list box.

i used the below expression but it doesn't work.Please any one can suggest me how to achieve it.

=if(TP_YN='0','Individual','Fleet','both')

pick(Match(TP_YN,'0','0','0'),'Individual','Fleet','Both')

Thanks in Advance

Regards

Krishna

Re: Expression in List Box

Fri, 09 Jan 2015 08:42:55 GMT

you have an extra parameter to your if statement there,

should be

If([Condition], [True], False])

you have 'both' which is causing an error

=if(TP_YN='0','Individual','Fleet') should work fine in itself, not sure where the 'both' actually comes in to what you are trying to achieve

hope that helps

Joe

Re: Expression in List Box

morganaaron — Fri, 09 Jan 2015 08:43:33 GMT

Are your values 'individual' etc. meant to select something from a certain field? The first statement won't work as you have an If statement with 3 conditions (true, false and an extra one) - but this wouldn't give you what you want anyway, I'm guessing.

What is it you're going to do with the listbox?

Re: Expression in List Box

krishna20 — Fri, 09 Jan 2015 09:00:52 GMT

Hi ,

Ya i applied it already.its working fine.

=if(TP_YN='0','Individual','Fleet'). I need to include 'both ' now in the expression.This list box is a filter.. I need to show three values in the list box as Individual, Fleet, Both. How can we write for this?

Regards

Krishna

Re: Expression in List Box

Fri, 09 Jan 2015 09:04:48 GMT

Use the following Exp

if(condition,'Individual',

if(condition,'Fleet','both'))

Re: Expression in List Box

morganaaron — Fri, 09 Jan 2015 09:15:11 GMT

If you want to show all 3 at the same time, and it be a filter, you could load a new field from scratch with those 3 options as the field values, then use this field as a conditional show or inside of set analysis or...etc. to get whatever results you're after.

Re: Expression in List Box

tresB — Fri, 09 Jan 2015 09:28:11 GMT

Perhaps like this?

Re: Expression in List Box

Fri, 09 Jan 2015 09:34:42 GMT

Sounds like you really want a field in your application for this as a separate linked table with the three possible values within it, linked on the flag field.

Edit: just like the example tresesco has recommended below

Re: Expression in List Box

sunilkumarqv — Fri, 09 Jan 2015 10:09:45 GMT

try like this

=if(TP_YN='0','Individual',If(TP_YN<>'0','Fleet',If(TP_YN='0' or TP_YN<>'0','Both'))

Re: Expression in List Box

Fri, 09 Jan 2015 10:21:54 GMT

try to use nested if as everyone already suggest,understand your condition and then apply if condition

if(TP_YN=0,'Individual',if(TP_YN>0,'Fleet','Both'))