topic Re: How to remove Starging number in the Value ? in QlikView

How to remove Starging number in the Value ?

ramcena306 — Sat, 16 Nov 2024 00:48:52 GMT

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

Re: How to remove Starging number in the Value ?

Anil_Babu_Samineni — Mon, 20 Apr 2020 07:33:40 GMT

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

Re: How to remove Starging number in the Value ?

ramcena306 — Mon, 20 Apr 2020 07:40:06 GMT

Hi Anil,

I want results be like below,

CA
HMI
CA HMI
CLASSIC PANNEL
CONTROL PANEL
3K5RGTL

Ramesh

Re: How to remove Starging number in the Value ?

ramcena306 — Mon, 20 Apr 2020 08:02:57 GMT

Hi All,

Any suggestions on this ?

Re: How to remove Starging number in the Value ?

Frank_Hartmann — Mon, 20 Apr 2020 08:11:19 GMT

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

Re: How to remove Starging number in the Value ?

ramcena306 — Mon, 20 Apr 2020 08:24:23 GMT

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

Re: How to remove Starging number in the Value ?

Anil_Babu_Samineni — Mon, 20 Apr 2020 08:25:21 GMT

How about this?

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

Re: How to remove Starging number in the Value ?

ramcena306 — Mon, 20 Apr 2020 08:29:22 GMT

Hi Anil,

i am using

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

Re: How to remove Starging number in the Value ?

Anil_Babu_Samineni — Mon, 20 Apr 2020 08:51:58 GMT

Perhaps this way

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