topic Re: Currency in QlikView

Currency

Anonymous — Thu, 11 Feb 2016 10:57:09 GMT

I make 2 variables to convert the currency from KWD into $ and €

And the two expressions:

If(Vcur$='$',Sum(Balance02),Sum(Balance02)*Vrate$)

If(Vcur€='€',Sum(Balance02),Sum(Balance02)*Vrate€)

are working fine but separate.

So I need to merge between this two expressions to make 1 Expression, Once I select $ button the currency should changes to $, Once I select € button the currency should changes to €, and Once I select KD button the currency should changes to KD.

for more explanation please check the qvw file.

Best Regards,

Awadah

Re: Currency

avinashelite — Thu, 11 Feb 2016 11:04:16 GMT

try like this create a inline table for all your currency in the script

Currency:

LOAD * inline

[

Unit

Dollar

Euro

];

Then in the button >go to properties > Action> select in field >choose the field in first(Dollar) > value ..if the button is for Dollar than select Dollar

based on the selection write a if condition in the expression to set the values like

if(getfieldselections(Unit)='Dollar', Sum(Balance02),Sum(Balance02)*Vrate$,

if(getfieldselections(Unit)='Euro' Sum(Balance02),Sum(Balance02)*Vrate€)

)

Re: Currency

sunny_talwar — Thu, 11 Feb 2016 11:05:17 GMT

Changed some formulas and variables around, see if this is what you want

Re: Currency

Anonymous — Thu, 11 Feb 2016 11:28:14 GMT

Dear Sunny,

Yes this is what I want thanks a lot 😃