Cumulative and Exchange rate

Mon, 04 Jul 2011 07:25:06 GMT

Hi all,

if the user selects the Apr month, then i need to show the cumulative value from jan to Apr., then that value is multiplied by the Apr month Exchange amt.

i done that one by using set analysis.

but my problem is , if the user selects mar and Apr, then i need to show two column one is for Mar and another one is for Apr.

in Mar, cumulative value from Jan-Mar then multiplied by the mar month Exchange rate,

in Apr, cumulative value from Jan-Apr then multiplied by the Apr month Exchange rate,

could anyone help me to solve this issue...

thanks in advance....

Re: Cumulative and Exchange rate

Mon, 04 Jul 2011 09:48:11 GMT

Hi,

i m using the following expression

Sum({<Num_Select_YearMonth={'<=$(=max(Num_Select_YearMonth))'},

Select_Year={$(=MaxString(Select_Year))},

Ex_MonthYear={'$(=max(Select_YearMonth))'}

>}Amt* Exchange_Amt_Avg)

Its working fine to see only one month...

but i dont know how to do for multiple months, based on the month selection...

Could anyone help me to solve this issue...

thanks in advance...

topic Re: Cumulative and Exchange rate in QlikView

Cumulative and Exchange rate

Re: Cumulative and Exchange rate