topic Re: Dynamic Dimension Logic in QlikView

Dynamic Dimension Logic

Thu, 03 Jul 2014 07:19:13 GMT

Hi Folks,

I am facing some issue in my development,

The logic is that I have Country Column with different Price Rate, Each country has its own currency Rate.

now the problem is that i am not able to multiply Amount with Respect to the Currency of the different Country.

& I need it into pivot table, any suggestions will be appreciated.

Thanks in Advanced,

Max

Re: Dynamic Dimension Logic

tresB — Thu, 03 Jul 2014 07:26:45 GMT

May be you are trying like:

=Sum(Price)*CurrRate // not correct, rather try like

=Sum(Price*CurrRate) // could work for you

Re: Dynamic Dimension Logic

Thu, 03 Jul 2014 08:29:07 GMT

Hi,

Try to do the Exchange rate calc in the script level. It would make things easier.

Regards,

Prabhu

Re: Dynamic Dimension Logic

Thu, 03 Jul 2014 08:34:00 GMT

Hi Tresesco & Prabhu,

Thanks, but i do not want to make any changes into script level & Currency Factor is identify by their Code based on it needs to be define.

Re: Dynamic Dimension Logic

tresB — Thu, 03 Jul 2014 08:36:24 GMT

Not very clear, could you post a sample qvw or explain with example? However, the solution I suggested was meant for front-end and not script.

Re: Dynamic Dimension Logic

Thu, 03 Jul 2014 08:42:20 GMT

Hi Tresesco,

Thanks for your help it works fine in single case. but in my case there are two type of currency exist Type 1 & Type 2, where both types are depend on two different dimensions, in that case your given solution get failed so i want to make it as dynamic.