topic how to develop a comparison table with actual and target values? in QlikView

how to develop a comparison table with actual and target values?

Thu, 30 Sep 2010 11:25:51 GMT

Hi Qlikers,

I need help on develop a table as below.

But this table cannot be build using Pivot or Straight Table or even Table Box.

Does anyone know how to develop this as i know the first column should be the words that we can key into field, is not a dimension that we can pull from database.

Below are the only result that i can get. But i need the left column name and i have more than 10 criteria to compare.

how to develop a comparison table with actual and target values?

Thu, 30 Sep 2010 15:34:20 GMT

It seems nobody know how to solve? or do we have relevant post regarding this topic?

how to develop a comparison table with actual and target values?

Thu, 30 Sep 2010 16:50:08 GMT

Hello,

for the dimension you can use a valuelist:

valuelist('Actual Sales Vs Target Sales','TotalRevenue','Gross Margin')

and in the part of expression the first expresion for Target Sales should be something like this:

pick(match(valuelist('Actual Sales Vs Target Sales','TotalRevenue','Gross Margin'),'Actual Sales Vs Target Sales','TotalRevenue','Gross Margin'), <Formula of Actual Sales Vs Target Sales >, <Formula of TotalRevenue>, <Formula of Groos Margin>)

hope this helps!!

Regards