Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use functions in load inline?
I know this problem can be solved in different ways, but I'm just curious if it's possible to use functions in Inline.
For example:
Table:
LOAD * Inline [
a
IterNo()
]
While IterNo () <= 10;
No, using LOAD INLINE
doesn't support loops like IterNo()
in Qlik, since INLINE
loads data from manually entered values, not dynamically generated ones. But it supports evaluating $ sign expansions. something like below:
https://community.qlik.com/t5/QlikView-App-Dev/How-use-a-function-in-load-inline/td-p/1333060.
You dont need to use inline for the above requirement with while and iterno(). it could be done like below:
Table:
LOAD
IterNo() as a
AutoGenerate 1
While IterNo() <= 10;
No, using LOAD INLINE
doesn't support loops like IterNo()
in Qlik, since INLINE
loads data from manually entered values, not dynamically generated ones. But it supports evaluating $ sign expansions. something like below:
https://community.qlik.com/t5/QlikView-App-Dev/How-use-a-function-in-load-inline/td-p/1333060.
You dont need to use inline for the above requirement with while and iterno(). it could be done like below:
Table:
LOAD
IterNo() as a
AutoGenerate 1
While IterNo() <= 10;
Okay... Functions cannot be used in Inline.