adding multiple calculations to external field and creating a table with output

Fri, 09 Nov 2012 05:42:13 GMT

Dear All,

I have a requirement on displaying the Different KPI's output in a Straight table but the dimension is as external.

Here I explain the scenario

I have to display the measures like SalesValue,Inventory,Profit,Cost,Inventory Cost etc.

SalesValue,Profit,Cost coming from one transactional table with seperate dimensions

Inventory and Inventory Cost comes from another transactional table and bothe Sales and Inventory tables are seperate.

I have to display a table with KPI's as

Dimension YTD PYTD

Sales Value YTD Sales PYTD Sales

Profit YTD Profit PYTD Profit

Cost YTD Cost PYTD Cost

Inventory YTD Inven. PYTD Inven.

Inven. Cost YTD Inv. Cost PYTD Inv. Cost

Here the dimension i have to create a inline and associate the measures with them, and my Measures are not fixed to YTD and PYTD it may have to changed to different KPI's dinamically.

So I would be able to created by using a function (Pick). It works fine taking little longer time.

However I need a better solution which will give me output faster by using any other functions.

Your help is appriciated. Thank you.

Chenna

Re: adding multiple calculations to external field and creating a table with output

Fri, 09 Nov 2012 06:12:20 GMT

Hi Chenna,

Can You Share Your Test App With Me.

Regards,

Nirmal.

topic adding multiple calculations to external field and creating a table with output in QlikView

adding multiple calculations to external field and creating a table with output

Re: adding multiple calculations to external field and creating a table with output