Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

instead of loading inline?

LOAD * INLINE [

     Comlum1

    A

    B

    C

];

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Use calculated dimension like

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

View solution in original post

3 Replies
stigchel
Partner - Master
Partner - Master

Use calculated dimension like

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

ashfaq_haseeb
Champion III
Champion III

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

stigchel
Partner - Master
Partner - Master

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)