Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
Can anyone please tell me if we can write expression in Load * Inline[];?
If yes, please give some example.
Thanks and Regards,
Vivek
Thanks;
But my problem is, I want to print each value by different expression.
Let's say,
Load * Inline
[
Col, Col1, Col2
A, Expression1, Expression2
B, Expression1, Expression2
];
where A and B are any text.
A concrete example of which data should be loaded and should return which results would be quite useful.
- Marcus
Load * Inline
[
temp, high
temp1, count({$<HighAcceptPriority={1},HighRejectPriority={1}>}ProductID)
]
this is my expression.
But in the table it's giving me output as
temp | high |
1 | count({$<HighAcceptPriority={1},HighRejectPriority={1}>}ProductID) |
where 1 is value of temp1 in temp column.
Please suggest some solution!
Thanks and Regards,
Vivek
From a Qlik point of view it's just a string and won't be evaluated in any way. The only possibility to evaluate such string is the use from a $-sign expansion like: $(=YourExpressionField) but it creates an adhoc-variable what meant it will be evaluated only once before the calculations of the object are executed and applied there for each row.
In short: your approach won't work. Of course there are ways to bypass it but they are neither trivial nor have they much benefit in the most usecases. Therefore my suggestion: just keep it simple by writing all needed expression there where you need them and switching to the really advanced stuff only if there is really no easier way.
- Marcus
Thanks Marcus!
Regards,
Vivek
Hello all,
I was facing the same issue but as an alternative solution I managed to do the following:
MetricShowExpression:
LOAD * INLINE
[Metric, ExpressionTable
Orders, vOrders
Invoices, vInvoices
Shipments, vShipments
];
LET vExpressionTableAux = '=ExpressionTable';
LET vExpressionTable = '=$'&'(vExpressionTableAux)';
You will be able to show in a table the metrics (Orders,Invoices,Shipments) but not all together. Add in the expression Definition $(vExpressionTable)
For my example I used a listbox and when I select Orders display vOrders and so on.
I hope my example helped you.
-Panos