topic Re: Load a Field on Data Load Editor - Qlik Sense in App Development

Load a Field on Data Load Editor - Qlik Sense

Anonymous — Fri, 10 Nov 2017 16:04:23 GMT

Hi all!

I'm trying to load a field based on another field's values, but I'm not getting it. Can anyone help me please?

Thank you!

Sofia Vaz

Re: Load a Field on Data Load Editor - Qlik Sense

Ralf_Heukäufer — Fri, 10 Nov 2017 17:11:40 GMT

Hello Sofia,

for what reason is ther a 1< for the second today() and so on i dont think thats right

and at the end i would write today()-LateDisp > 16 in another if clause instead of the else.

Re: Load a Field on Data Load Editor - Qlik Sense

diegofcaivano — Fri, 10 Nov 2017 18:13:55 GMT

Hi!

You cannot define greater/less than conditions with that syntax.

For each case, you should split the expression in two using the "and" operator.

If(Field>=0 and Field<=10, ..., If( ... ))

Hope this helps.

Regards.

Re: Load a Field on Data Load Editor - Qlik Sense

shraddha_g — Sat, 11 Nov 2017 13:38:25 GMT

Try,

If( (today()- LateDisp) =1, '1 Day Late',

If( (today()- LateDisp) > 1 and (today()- LateDisp) <=3 , '2 to 3 days late',

if( (today() - LateDisp) >3 and (today() - LateDisp) <=6 , '3 to 6 days late',

If( (today() - LateDisp) >6 and (today() - LateDisp) <=15 , '7 to 15 days late' ,'+16 days late'))))

Re: Load a Field on Data Load Editor - Qlik Sense

Anonymous — Mon, 13 Nov 2017 09:46:16 GMT

Thank you for your help!

Now I can load the scrip, but I can't use the created field because it doesn't appear as an option when I'm editing the sheets ... Do you have any idea what I might be doing wrong?

Thank you once again!

Re: Load a Field on Data Load Editor - Qlik Sense

Ralf_Heukäufer — Mon, 13 Nov 2017 09:49:12 GMT

Have you an "as Intervals" behind the clause?

Re: Load a Field on Data Load Editor - Qlik Sense

shraddha_g — Mon, 13 Nov 2017 09:52:02 GMT

Have you given any name for this generated field. For ex

If( (today()- LateDisp) =1, '1 Day Late',

If( (today()- LateDisp) > 1 and (today()- LateDisp) <=3 , '2 to 3 days late',

if( (today() - LateDisp) >3 and (today() - LateDisp) <=6 , '3 to 6 days late',

If( (today() - LateDisp) >6 and (today() - LateDisp) <=15 , '7 to 15 days late' ,'+16 days late')))) as BucketField

Re: Load a Field on Data Load Editor - Qlik Sense

Anonymous — Mon, 13 Nov 2017 09:56:09 GMT

Yes, I have this:

Load

If( (today()- LateDisp) =1, '1 Day Late',

If( (today()- LateDisp) > 1 and (today()- LateDisp) <=3 , '2 to 3 days late',

if( (today() - LateDisp) >3 and (today() - LateDisp) <=6 , '4 to 6 days late',

If( (today() - LateDisp) >6 and (today() - LateDisp) <=15 , '7 to 15 days late' ,'+16 days late')))) as LateOrdInterval;

Re: Load a Field on Data Load Editor - Qlik Sense

shraddha_g — Mon, 13 Nov 2017 10:00:23 GMT

You are not getting this field in Front End?

Can you check whether you have dropped that table somewhere?

Re: Load a Field on Data Load Editor - Qlik Sense

Anonymous — Mon, 13 Nov 2017 12:23:36 GMT

Yes, the field doesn't appear in the FrontEnd... and I don't know how to check if i've dropped the table somewhere... But that's ok, Shraddha Gajare ! I'll ask my IT colleagues for help.Thank you so much for your time!