topic Re: Better formula statement than if for picking value in QlikView

Better formula statement than if for picking value

Thu, 29 Jan 2015 15:42:17 GMT

Is there a better statement than using if to select/display a value

I have data in rows like this:

Salesperson Position

Joe Primary

Mary Split

I am using a text field to display the "Primary" salesperson. Is there a better formula/statement than

if(Position='Primary',Salesperson,)

Re: Better formula statement than if for picking value

srchilukoori — Thu, 29 Jan 2015 19:34:59 GMT

Did you try using Only(<Position = {'Primary'}>Salesperson)?

Re: Better formula statement than if for picking value

Thu, 29 Jan 2015 20:17:34 GMT

THis comes up as an invalid formula

Re: Better formula statement than if for picking value

Thu, 29 Jan 2015 20:18:58 GMT

I used

pick(match(Position,'Primary'), 'Salesperson') and the above "IF" statement. Both return the value I want. The problem is, it only returns the value if i pick "Primary" in a list box.

I want this field to ALWAYS display the primary salesperson

Re: Better formula statement than if for picking value

srchilukoori — Thu, 29 Jan 2015 22:04:35 GMT

Please upload a sample of your application.

Re: Better formula statement than if for picking value

MarcoWedel — Fri, 30 Jan 2015 00:12:23 GMT

Hi,

to let the primary salesperson be displayed regardless of any selections, you could use this expression:

=Only({1<Position={'Primary'}>} Salesperson)

hope this helps

regards

Marco

Re: Better formula statement than if for picking value

MarcoWedel — Fri, 30 Jan 2015 00:14:00 GMT

missing brackets:

Only({<Position = {'Primary'}>} Salesperson)

hope this helps

regards

Marco

Re: Better formula statement than if for picking value

Fri, 30 Jan 2015 22:44:14 GMT

Excellent - this works perfectly.

Thanks.

Re: Better formula statement than if for picking value

MarcoWedel — Fri, 30 Jan 2015 23:06:49 GMT

You're welcome

Regards

Marco