Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone use calculated dimension to generate a dimension with hard coded values
instead of loading inline?
LOAD * INLINE [
Comlum1
A
B
C
];
Use calculated dimension like
=ValueList('A','B','C')
Yes
have a look at valuelist() and valueloop() functions.
http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/01/valuelist-for-those-tricky-situations
Regards
ASHFAQ
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)