Languages and Regional Formats

[#1]

Hi,

I have solved the issue of translating the site to an extent ... I am struggling a little with various formats ... Date, Money etc.

I have set up an Inline table to get try and get in working ...

Region, Format, FormatType
EUR, 'DD/MM/YYYY', Date
USD, 'MM/DD/YYYY',Date

I am a little stuck what to do from there ... perhaps something like =Num(sum(thevalue), $(vregion, Format))

Any help greatly appreciated

Thanks

Lee

[johnw]

I've expanded a currency conversion example to include date formats. Perhaps it will give you some ideas.

[#3]

Hi John. Thanks for this ... I can see what is going on and I could just copy this straight in but I don't fully understand what the $1 expansion is doing if I am honest ... I like to try and understand things rather than just swipe them because if they 'break' I can then at least fix them.

Would you mind just explaining the $1 ... sorry to trouble you.

Thanks

Lee

[#4]

I have it ... Previous Selection.

[johnw]

In this case it's the first parameter rather than the previous selection. QlikTech unfortunately decided to use the exact same syntax to mean different things depending on context, which I think was a very poor design choice. But regardless, it's what we're stuck with. In set analysis, $1 is indeed the previous selection. But in this context, it indicates the first parameter, $2 the second parameter, and so on. So I've used a variable to make a new money "function" that takes one parameter, and then takes the currency, decimal format and thousand format from a table based on the currently-selected currency.

[#6]

Oh dear me ... it is hard enough at times to learn to develop in QlikView without nonsense like that.

Thank you for clearing that up though.