Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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
HI Sushil,
can u send me the dual function script
Hi you can do it in script as well as UI
..write
if(FieldName='1','Name1',
if(FieldName='2','Name2',
......))
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;
hi Sujeet,
i have one Field
MF_INCL
1
2
3
4
9
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)
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')
Hi Venugopal,
Thanks for ur help..
can u explain me how the Pick nad Match Functions will work in this
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.
Thanks Venu