topic Re: Help with list box in QlikView

Help with list box

Tue, 13 Oct 2015 12:09:47 GMT

Hi Guy's

I have something im trying to do , hope its possible.

I have a field in my database called Authorization Type which has two results, 1 and 2. I would like to make this more user friendly by making the list box display crack for 1 and NIS for 2 instead of just displaying a 1 or 2.

Is this possible at all ?

Help is very much appreciated.

Re: Help with list box

sunny_talwar — Tue, 13 Oct 2015 12:13:23 GMT

May be this for your listbox expression:

Pick([Authorization Type], 'Crack', 'NIS')

Re: Help with list box

Tue, 13 Oct 2015 12:17:00 GMT

yes you can

You can add an IF() function in your load script to look at a value and set the field

if ([Days] > 45,'Over 45'))) as Status - this example is checking the value in the days field and based on the value setting the sttus field. If you have to values your test would be something along the lines of

If([Authorization Type] = 1, 'Yes','No) as [Auth Type] and use Auth Type for your list or as [Authorization Type]

Re: Help with list box

Tue, 13 Oct 2015 12:17:43 GMT

That worked perfectly , thank you so so much

Re: Help with list box

sunny_talwar — Tue, 13 Oct 2015 12:19:15 GMT

Awesome