topic Re: script in QlikView

script

rathnam_qv — Wed, 23 Oct 2013 05:06:50 GMT

Hi all,

i have one field type=1,2,3,4,9.....instead numbers i want to display Names for that Numbers..

how it can be done....help me

Thanks in advance!!!

Smiley

Re: script

sushil353 — Wed, 23 Oct 2013 05:13:38 GMT

Hi,

Please explain your issue with an example.

Otherwise you can use mapping table to replace the number with name or use dual function.

HTH

Sushil

Re: script

rathnam_qv — Wed, 23 Oct 2013 05:47:25 GMT

HI Sushil,

can u send me the dual function script

Re: script

sujeetsingh — Wed, 23 Oct 2013 06:06:45 GMT

Hi you can do it in script as well as UI

..write

if(FieldName='1','Name1',

if(FieldName='2','Name2',

......))

Re: script

sushil353 — Wed, 23 Oct 2013 06:06:55 GMT

Tab1:

LOAD * Inline

[

Name

One

Two

Three

Four

Five

Six

Seven

Eight

Nine

];

Table:

LOAD dual(Name,RowNo()) as name_no,

rowno() as no

Resident Tab1;

DROP Table Tab1;

Re: script

rathnam_qv — Wed, 23 Oct 2013 06:34:40 GMT

hi Sujeet,

i have one Field

MF_INCL

i am using set analysis as sum({<MF_INCL={'1','2'}>}GOAL) in pie chart

in the resultant pie chart i am getting 1,2 in the right side of the chart.

my requirement is instead of that numbers i want to display Low ,Mod(for 1,2)

Re: Re: script

Wed, 23 Oct 2013 06:48:11 GMT

Hi,

I think, we can solve this by using PICK and MATCH functions.

We could do this in two ways, either Script or Calculated dimension. See the attachment.

PICK(Match(MF_INCL, 1,2,3,4,5,6,7,8,9), 'One', 'Two', 'Three', 'Four', 'Five', 'Six', 'Seven', 'Eight', 'Nine')

Re: Re: script

rathnam_qv — Wed, 23 Oct 2013 08:55:06 GMT

Hi Venugopal,

Thanks for ur help..

can u explain me how the Pick nad Match Functions will work in this

Re: script

Wed, 23 Oct 2013 13:05:26 GMT

Hi,

Simple defination:

Match() - It compares the string from a list of string values and return the position of matching text/vale. If not found then it can result the value 0.

Example:

Match(Var, 'Jan','Feb','Mar') - If Var value is "Feb" then the result is 2.

Pick() - This can return the expression value from the specific position in expression list.

Example:

Pick(2,'A','B','C') - result is B

I hope, you are clear now.

Re: script

rathnam_qv — Thu, 24 Oct 2013 06:46:36 GMT

Thanks Venu