Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
sagaraperera
Creator
Creator

dimention

Untitled.jpg

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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

];


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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

];


talk is cheap, supply exceeds demand