Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Mr. Paul,
Use:
Let currency = 1.5;
And in load script, should be:
S_Price*$(currency) as LIST_PRICE_SGD_LOAD,
Regards,
Sokkorn
My raw data file. In case you need it.
Hi Mr. Paul,
Use:
Let currency = 1.5;
And in load script, should be:
S_Price*$(currency) as LIST_PRICE_SGD_LOAD,
Regards,
Sokkorn
Thank you very much Sokkom. yes this is what i want.
by the way your full time job are QV programmer ?
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
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
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