Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vinod2086
Creator II
Creator II

How to split units in one field

Hi Friends,

i need one help i have one field like

field with unit
OTHERS
33.512
11 Mbps
2 kbps
40.20 gbps
12 gb

but here i want to split field with unit into[ field value] and [field  unit].

Thanks in Advance.

14 Replies
vinod2086
Creator II
Creator II
Author

Hello Sushil,

as u mentioned code not giving correct results,

am expecting  out put see below table

field_val       unit

Others

33.512

11               Mbps

40.20           gbps.

and am not understanding how to use sub field function in this case.

Kushal_Chawda

Try

Subfield ([Field value with unit],' ',1) as FieldValue

Subfield ([Field value with unit],' ',2) as Field with unit

vinod2086
Creator II
Creator II
Author

...

IAMDV
Luminary Alumni
Luminary Alumni

Vinod 4186 wrote:

Hi kush,

i tried above logic but not working


Vinod - How come the above post is the correct answer? Please can you post detailed answer if you know it or mark the correct answer as "correct".

its_anandrjs

Hi Vinod,

It seems not good the answer for the question, Some where it is misguide the thread also.

Regards

Anand