Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
commonqlik
Creator III
Creator III

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

commonqlik
Creator III
Creator III
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
Partner

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

commonqlik
Creator III
Creator III
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
Partner

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

commonqlik
Creator III
Creator III
Author

i will check and get back to u

Thanks