topic Re: dimention in QlikView

dimention

sagaraperera — Wed, 22 Apr 2015 07:42:28 GMT

cause the picture below and I want are the cause EXPRESSION 1A, 1C, 1D, such as DIMENSION PRODUCT CODE from ever taking such as

FIRE = 1A, 1C, 1D, MOTOR = 1X, 1Z, bringing a separate FIELD is remembered as 3C FIELD FIRE under it, MOTOR, such as have transformed. When the cause of ඒහිදී select whether FIRE FIELD 1A, 1C, 1D column values under a separate cause fewer build up inside it EXPRESSION

please help

sagara

Re: dimention

Gysbert_Wassenaar — Wed, 22 Apr 2015 08:07:17 GMT

I don't really understand your question. But perhaps you're asking how to group values from one field. You can do that by creating a new field in the script, for example by creating a new inline table:

NewDim:

LOAD * INLINE [

Group, PRD_CODE

FIRE, 1A

FIRE, 1C

FIRE, 1D

MOTOR, 1X

MOTOR, 1Z

....

etc

];