topic Re: Create a table in qlikview in QlikView

Create a table in qlikview

kushalthakral — Sat, 31 May 2014 10:17:03 GMT

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 — Sat, 31 May 2014 10:32:02 GMT

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 — Sat, 31 May 2014 10:35:59 GMT

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)