topic Re: Static Column in KPI in QlikView

Static Column in KPI

n1ef5ng1 — Thu, 02 May 2013 07:01:30 GMT

Hi guys, I am currently working on a KPI report

basically the table structure will be like

Revenue Target Jan Feb March .... Dec YTD

I am able to generate data for month and revenue

however, is there any where that I can fit in the target column that is suppose to be key in manually without duplication due to month as my dimension

Basically my dimension consist of Months and Value List for Revenue

Expression is just the value list

Any help is appreciated

Re: Static Column in KPI

Thu, 02 May 2013 07:08:48 GMT

use crosstable.

Crosstable(month,revenue)

load * from table1;

Re: Static Column in KPI

Thu, 02 May 2013 07:11:44 GMT

Crosstable(month,Revenue)

load

Target,

Revenue,

jan, feb,mar, apr,....

from table;

Re: Static Column in KPI

n1ef5ng1 — Thu, 02 May 2013 07:13:59 GMT

have to edit the script? possible to work on dimension or expression?

Re: Static Column in KPI

n1ef5ng1 — Thu, 02 May 2013 07:15:09 GMT

my revenue column is an valuelist input

Re: Static Column in KPI

Thu, 02 May 2013 07:49:44 GMT

you have to write it in edit script.

then use month as dimension and Revenue in expression of your chart or table

Crosstable(month,Revenue)

load

Target,

jan,

feb,

mar,

apr,....

from table;