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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
maniram23
Creator II
Creator II

load

Hi experts,

what is the use of 'only' keyword ? why we are using 'only' keyword in partial reload ?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

1.png

abc:

load * inline [

  Month, Price

  1, 100

  1, 100

  2, 200

  2, 201

  3, 300

  ];

Example:

Load Month, only(Price) as OnlyPriceSoldFor Resident abc group by Month;

DROP Table abc;

View solution in original post

4 Replies
Not applicable

Hi,

The below link will help you to understand about Only Function.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/03/the-only-function

petter
Partner - Champion III
Partner - Champion III

‌Only is both a script function and a chart function.  The script version is not limited to partial reload.

maniram23
Creator II
Creator II
Author

Thanks for immediate response.

can u explain with suitable example.?

maxgro
MVP
MVP

1.png

abc:

load * inline [

  Month, Price

  1, 100

  1, 100

  2, 200

  2, 201

  3, 300

  ];

Example:

Load Month, only(Price) as OnlyPriceSoldFor Resident abc group by Month;

DROP Table abc;