Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
sumanyedla121
Contributor III
Contributor III

How to consider the number from combination data

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. 

Calculation.PNG

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

Please see the attached and hope this helps:

View solution in original post

3 Replies
trdandamudi
Master II
Master II

Please see the attached and hope this helps:

rkpatelqlikview
Creator III
Creator III

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

sumanyedla121
Contributor III
Contributor III
Author

Its simple and more helpful for everyone.

Thank you.