topic Re: Significance of %column name in Inline Table in QlikView

Significance of %column name in Inline Table

Thu, 18 Jul 2013 15:50:58 GMT

Hi Team,

What is the significance of uisng %variable name (or column name ) in inline tables.

What is the difference in using $varaiable name and simply variable name . Can someone please clarify ?

/*LOAD * INLINE [

%ToggleField, %Displayed

Hub, Hub

Product Group, Product

];

Thanks

Nirmal.

tresB — Thu, 18 Jul 2013 16:16:26 GMT

i guess '%' does not have special significance in this circumtances, while '$' has a significant role in variable expansion.

Say, you write:

Let var1 = 100;

Load var1 as Field1,

$(var1) as Field2

here you would get 'var1'(i.e - string) in Field1, and 100(numeric) in Field2. or in other words, you can say that-

$( variablename) expands to the value in variablename.