% in InLine Load

[Sai_Krishna]

Load * InLine [
Type, "Num_Format"
Rev, 0.00%
Cost, 0.00
];

Above load, both records are loading 0.00%. How to handle % in inline load. Tried '0.00%' and "0.00%" AND [0.00%]. Its not working.

[sergio0592]

Hi,

You can use num() function in your load inline. But what is the expected output?

[Sai_Krishna]

It should load as it is but now it loading with % to all records (Below Screenshot). I will use this in Pivot expression like Num(SUM(...),Num_Format). This will improve performance instead of having if condition and defining number format.

[tresesco · Accepted solution]

This is another classic example of what @rwunderlich  has noticed and has come up with a fix. Check it here: https://qlikviewcookbook.com/2020/02/num-script-vs-chart/.

Though this is not about num() unlike Rob's post, but it seems that the qlik engine behavior is actually working on same logic and the format values are implicitly being treated similarly here. The new qlik engine QIX is a bit more intelligent now, and sometimes intelligent people do/interpret simpler things a bit differently that you didn't expect. 😋 

Try like:

Load *,

          Text("Num_Format") as "Num_Format_Corrected"

InLine [
Type, "Num_Format"
Rev, 0.00%
Cost, 0.00
];

[Sai_Krishna]

Thanks for quick solution tresesco (MVP).