Create a table in qlikview

[kushalthakral]

Hi All

i want to create a table like below in qlikview

is it possible

Classification	Target	Actual	Variance
A	10	9	1
B	15	10	5
C	20	10	10
D	18	15	3

where classification is Expression label not dimensions

so need to show expressions one after another

Thanks

Kushal Thakral

[its_anandrjs]

Can you elaborate more with any samples

It it is table then you can do this in the load script

Load

Classification,

Target,

Actual,

Target - Actual =  Variance

From Location;

[swuehl]

I think you need at least one dimension here, but you can use a calculated dimension, like

=aggr(

if( sum(Sales) > 1000,'A','B')

,Customer)