Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See WhyThousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
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
Anil_Babu_Samineni

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
Anil_Babu_Samineni

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)
ramcena306
Creator
Creator

Hi Anil,

I want results be like below,

CA
HMI
CA HMI
CLASSIC PANNEL
CONTROL PANEL
3K5RGTL

 

Ramesh

ramcena306
Creator
Creator

Hi All,

 

Any suggestions on this ?

Frank_Hartmann
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
];

ramcena306
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

Anil_Babu_Samineni

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)
ramcena306
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.

Anil_Babu_Samineni

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