topic Changing the way data is displayed within a field in QlikView

Changing the way data is displayed within a field

hopkinsc — Thu, 25 Nov 2010 12:22:30 GMT

Hi,

I have a field called 'Narrative', Within this field are loads of descriptions (See attached spreadsheet)

What i want to do is group them together and rename them.

e.g.

All descriptions starting with 'Goods ' to be renamed 'Goods Received'

All descriptions starting with Stock' to be renamed 'Stock Check'

I know how to do this within the application :

=IF(UPPER(Narrative) like 'Stock*','Stock Checking' ,Narrative)

but i want to do it in the load script. Can anyone tell me if it can be done please?

Changing the way data is displayed within a field

Thu, 25 Nov 2010 12:47:39 GMT

Hi,

you could do something as under:

if ( mid ( Narrative, 1 , 5 ) = 'Goods' , 'Goods Received' , Narrative ) as ModifiedNarrative

Similarly multiple if statements could be added within the script

Changing the way data is displayed within a field

hopkinsc — Thu, 25 Nov 2010 12:55:12 GMT

Thanks Umang, can you tell me hwta the (Narrative, 1,5) means in the statement please?

Changing the way data is displayed within a field

Thu, 25 Nov 2010 12:58:27 GMT

The function used is Mid - which searches the text "Narrative" from the first alphabet & looks for takes the first five alphabets to match it with "Goods"

Changing the way data is displayed within a field

hopkinsc — Thu, 25 Nov 2010 13:03:37 GMT

Ok, thanks. That works great for the one example (Goods).

i'm trying to add more though, how would i include multiple descriptions.

E.g.

Goods = Goods Receiving

Stock = Stock check

Ordereing = Stock Adj (Ordering)

etc

Thanks

Changing the way data is displayed within a field

kaushalview — Thu, 25 Nov 2010 13:06:51 GMT

Hi,Hopkinsc

you could slove your Problem as given below .

if(wildmatch(Narrative,'Go*')>0,'Goods Received',

if(wildmatch(Narrative,'St*')>0,'Stock Check')) as Narrative

ok.

Changing the way data is displayed within a field

Thu, 25 Nov 2010 13:10:33 GMT

You would need to build the formula, I am writing down as example

if ( mid ( Narrative, 1 , 5 ) = 'Goods' , 'GoodsReceiving' ,
if ( mid ( Narrative, 1 , 5 ) = 'Stock' , 'Stockcheck',
if ( mid ( Narrative, 1 , 8 ) = 'Ordering' , 'StockAdj(Ordering)' , Reason ))) as ModifiedNarrative