Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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)