Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rquirement on currency

Hi Folks,

pls have a look into this ,

how to achieve this in front end



i have t1 and t2 tables
t1 is having country and currency value ,where t2 is having rate and actual amount 
here my requirement is
if i click on newcheck in currency_n then i should see that sum({<period={201703}>}actualamount)*sum({<period={201703}>}rate) which is avaliable in upper chart
but here the problem is if add cyrrency as dimenison i am getting the correct result ,but i dont want see currency in dimension ,if i hide also country a will come twice which is wrong

idealy it should give the value for a in result column 154.8 but it is giving 303.4 but when i add currency as dimenion am getting the correct value .

how to achieve this
please le me know for any clarification on requirement


Please find attached application


8 Replies
prma7799
Master III
Master III

Please share some sample expected output.

Or try this

Anonymous
Not applicable
Author

when u add currency as dimension u will get the data in chart is output

but same result I want with out currency as dimension

pls have a look into the chart and let me know anything required

andre_mueller
Partner - Contributor II
Partner - Contributor II

Hi,

not sure what exactly your requirements are, but maybe you can use an aggr function like

= Sum(
Aggr(
if(currency_n<>'newcheck',sum({<period={201703}>}amount),sum({<period={201703}>}actualsamount)* sum({<period={201703}>}rate))
,
country, currency)
)

Regards

prma7799
Master III
Master III

Please share your exact output.

which measures i have to use amount or actual sale amount

pooja_prabhu_n
Creator III
Creator III

Hi,

You can try calculating the sum at the script level.

Please refer the attached qvw file.

Thanks,

Pooja

Anonymous
Not applicable
Author

it was working fine,

but i wanna do it in ui level,

because if months from ui selections  like apr and jan

then apr month rate should multipy with jan actual amount .

if we do it in script level we cant achieve this (where actual amount multipy with same month amount rate)

andre_mueller
Partner - Contributor II
Partner - Contributor II

Hi,

had you checked my answer and tried the expression in your Chart as "result"? As far as I understood you, it gives you the results you expect, 154,8 and 408, even if you remove the dimensions currency and country. And it works in UI as you want. What other requirements you have, that not work with that solution?

Cheers

Anonymous
Not applicable
Author

i will check and get back to u

Thanks