topic Re: List Box Edits in QlikView

List Box Edits

Anonymous — Mon, 23 Mar 2015 19:49:45 GMT

Is there a way to change a value in a list box?,For example, I have a list box where the value is apple but I want it to read Granny Apple and when you filter on Granny Apple results from Apple should appear in your table box, is that possibe?

If not, I can make these edits in the script but I will need help

List Box

Apple

Banana

Orange

Results:

List Box

Granny Apple

Banana

Orange

//Script syntax:

Apple:

SQL

xxxxxxxxxxxxxx

Distinct:

SQL

xxxxxxxxxxxxxx

Final Table:

inner join (Apple)

Load

Columns from Distinct

Resident [Distinct]

Drop table [Distinct]

Where would I make edits to the Apple table , would I have to create a separate load statement for Apple?

Re: List Box Edits

maxgro — Mon, 23 Mar 2015 20:01:40 GMT

maybe adding a field (NewField)

source:

load * inline [

Field, Value

Apple, 1

Banana, 2

Orange, 3

];

left join (source)

load *,

if(Field='Apple', 'Granny Apple', Field) as NewField

Resident source;

Re: List Box Edits

Anonymous — Mon, 23 Mar 2015 20:19:40 GMT

Alternatively you can create the expression in the listbox itself. If(Field like 'Apple', 'Granny Apple', Field)

Re: List Box Edits

Anonymous — Tue, 24 Mar 2015 12:21:17 GMT

Exactly what I was looking for, thanks.

Re: List Box Edits

Tue, 24 Mar 2015 12:51:21 GMT

hi.

try this

if(Field='Apple', 'Granny Apple', Field) as NewField

Re: List Box Edits

Anonymous — Tue, 24 Mar 2015 18:38:53 GMT

How many IF statements can one have in the list box expression?

Re: List Box Edits

Anonymous — Tue, 24 Mar 2015 18:43:35 GMT

The reason I ask, I have a table below: 45 different columns that need to be added into a list box

ID Apply Banana Orange XXX xxx xxxx xxx xxx

1 x x x x

2 x x x

5 x x x

6...Thds of records

Re: List Box Edits

anbu1984 — Wed, 25 Mar 2015 05:34:50 GMT

Check this link

http://dailyqv.blogspot.in/2013/01/using-pick-and-match-functions-for.html

Re: List Box Edits

shanemichelon — Wed, 25 Mar 2015 06:13:11 GMT

It sounds like you really do need to modify your script to include a lookup type table. Effectively you need a dimension table to get the names.

So let us say that your data load script leaves you with a table like this:

ID	Fruit	Price	Qty
1	Bananna	10	2
2	Apple	15	3
3	Pear	18	5

Use inline script to add another table like this:

Fruit	FruitLongName
Bananna	Big Yellow Bannanna
Apple	Granny Smith Apple
Pear	Nice Pear

The common field name 'Fruit' will join the tables. Then in your list just use FruitLongName.

The load script for the dimension table would look like this:

Load * Inline [

Fruit, FruitLongName

Bannanna,Big Yellow Bannanna

Apple,Granny Smith Apple

Pear, Nice Pear

]

From what you have said it seems like you need to present this in a straight table rather than a list box.

remember that in Qlikview, you can select on the field in the table, it doesn't have to be a listbox.