How to make use of load script to get LSIT_PRICE_SGD = 100 ?

[#1]

Hi All

I use below script it work , but like to make it more dynamic and easy maintenance.

    S_Price*1.5 as LIST_PRICE_SGD, // This work but very hard to maintenance.

    S_Price*Currency as LIST_PRICE_SGD_,  // This work but need to search for var , prefer to use edit script.

So i create var :-

SET currency = 1.5;

LOAD * INLINE [

Country, Rate

SG, 1

MY, 2.4

INDO, 8300

THAI, 25

];

i try below script not working :-

//  S_Price*Rate as LIST_PRICE_SGD_LOAD,

//  S_Price*currency as LIST_PRICE_SGD_LOAD,

Paul

[#2]

My raw data file. In case you need it.

[Sokkorn · Accepted solution]

Hi Mr. Paul,

Use:

Let currency = 1.5;

And in load script, should be:

S_Price*$(currency) as LIST_PRICE_SGD_LOAD,

Regards,

Sokkorn

[#4]

Thank you very much Sokkom. yes this is what i want.

by the way your full time job are QV programmer ?

[#5]

Hi Sok

By the way i saw your profile at your web site. very detail. you also develop mobile app for QV ? Can share a bit more ? as this is the trend.

Paul

[Sokkorn]

Hi Mr. Paul,

Thanks for visited my site.

Yes of cause I also develop QlikView App for mobile. See, PC falling down and a huge tablet growth up. That why I decide to develop all app to fit with mobile.

My full time job is Regional Product Manager (ERP+BI). And for QlikView is the best BI tool for me. I do love this tool.

I am also looking for any QlikView project as well

Regards,

Sokkorn

[#7]

Hi Sok

Thank you for yr sharing.

I saw you came to singapore. Next time you happen come again let me know. May be we can meet up. Or if you come indonesia now I usually stay at jakarta.

Paul Yeo

+6593261804

Skype paulyeo_thai