topic Re: How to consider the number from combination data in QlikView

How to consider the number from combination data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts.

Please help on below data.my extracted data is combination of m/s^2,

Here. i need to calculate this m/s values multiplied with 18/5 and the km/h should be multiplied with 1.

Struking with splitting the values and calculations.

Re: How to consider the number from combination data

trdandamudi — Fri, 29 Jun 2018 14:47:57 GMT

Please see the attached and hope this helps:

Re: How to consider the number from combination data

rkpatelqlikview — Fri, 29 Jun 2018 15:05:56 GMT

Dear Suman,

You can use the below edit script.

LOAD *,

If(CleanedValues<10, (CleanedValues)*18/5, CleanedValues*1) as Calculateddata;

T1:

LOAD ExistValues,

//CleanedValues,

//Calculateddata,

subfield(PurgeChar(PurgeChar( PurgeChar(PurgeChar(ExistValues,' Acceleration forward or braking:'),' Max Speed:'),' km/h'),' Acceleration side to side:'),'^',1) AS CleanedValues

FROM

(ooxml, embedded labels, table is Sheet1);

Re: How to consider the number from combination data

Anonymous — Fri, 29 Jun 2018 15:11:00 GMT

Its simple and more helpful for everyone.

Thank you.