topic dimension with hard-coded value (other than load inline) in QlikView

dimension with hard-coded value (other than load inline)

Wed, 22 Oct 2014 11:49:12 GMT

Can anyone use calculated dimension to generate a dimension with hard coded values

instead of loading inline?

LOAD * INLINE [

Comlum1

];

stigchel — Wed, 22 Oct 2014 11:50:21 GMT

Use calculated dimension like

=ValueList('A','B','C')

ashfaq_haseeb — Wed, 22 Oct 2014 11:51:27 GMT

Yes

have a look at valuelist() and valueloop() functions.

Regards

ASHFAQ

stigchel — Wed, 22 Oct 2014 11:53:19 GMT

You can reference this dimension in the expression of a chart by repeating the dimension expression e.g.

if(ValueList('A','B','C')='A', SomeExpression)