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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Significance of %column name in Inline Table

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.

Labels (1)
1 Reply
tresB
Champion III
Champion III

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.