Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

How to remove Starging number in the Value ?

Hi All,

 

I have a field which is having values like 

1CA
2HMI
3CA HMI
4CLASSIC PANNEL
5CONTROL PANEL
63K5RGTL

Now , i want to remove or hide first numbers of the value like 1,2,3,4 till 8 in the reports.

Please help me on this.

 

Regards,

Ramesh 

1 Solution

Accepted Solutions

Perhaps this way

=' '& GetFieldSelections(Mid(NODE, 2))

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

8 Replies

What you want output for below regards? Ex: "63K5RGTL"

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Creator

Hi Anil,

I want results be like below,

CA
HMI
CA HMI
CLASSIC PANNEL
CONTROL PANEL
3K5RGTL

 

Ramesh

Creator
Creator

Hi All,

 

Any suggestions on this ?

Master II
Master II

Load *, if(isnum(left(F1,1)) and left(F1,1)<=8 ,replace(F1,left(F1,1),null()),F1) as test;
LOAD * INLINE [
F1
1CA
2HMI
3CA HMI
4CLASSIC PANNEL
5CONTROL PANEL
63K5RGTL
9JZZE
];

Creator
Creator

Hi Frank_Hartmann,

I want to do this in the frontend report.

and the below are the values not the fields.

 1CA
2HMI
3CA HMI
4CLASSIC PANNEL
5CONTROL PANEL
63K5RGTL
9JZZE

How about this?

Load Input, Mid(Input, 2) as Output From Table;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Creator

Hi Anil,

i am using 

=' '& GetFieldSelections(NODE) this expression in the Text Object, now i want to remove starting numbers from the NODE field.

Perhaps this way

=' '& GetFieldSelections(Mid(NODE, 2))

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post