topic Re: Expression to dimension in QlikView

Expression to dimension

Tue, 25 Jun 2013 06:52:54 GMT

Is there any code to change an expression to an dimension? (eg. sum(object) )

Re: Expression to dimension

alexandros17 — Tue, 25 Jun 2013 06:56:18 GMT

Any aggregation function (e.g. sum, avg, count, aggr .. etc) is performed through dimensions so you can't use these function in dimension ...

Hope it helps

Re: Expression to dimension

Tue, 25 Jun 2013 07:29:08 GMT

Description	TYPE	Jan2011-Jan2012	Jan2012-Jan2013
ASD	PENC	13123	7898
UHT	OPSI	12312	4356

This is an example on what i need to achieve. I have already set TYPE as an expression because 'PE' and 'NC' are two different field. It seems like i'm having two expression but i cant do it.

Re: Expression to dimension

Tue, 25 Jun 2013 09:44:04 GMT

just do it in ETL..Pls find below script..hope it will help u..

RawData:LOAD * INLINE [
Product,   Price,     Volume
P1, 10, 40
P2, 12, 50
P3, 20, 60
P4, 5,   70
P5, 15, 80

];

Data:LoadProduct,
     Price,
      Price As Value,
     'Price' As 'Measure',
           Volume
          Resident RawData;

Load

Product,
Price,
    Volume As Value,
   'Volume' As 'Measure',
     Volume

     Resident RawData;
     DROP Table RawData;

In Chart take Dimension as Measure and in expression Sum (Value)

Regards-Bika