Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Load a Field on Data Load Editor - Qlik Sense

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

9 Replies
Highlighted
Partner
Partner

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

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.

Highlighted
Partner
Partner

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

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.

Highlighted
Partner
Partner

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

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'))))

Highlighted
Creator II
Creator II

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

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!

Highlighted
Partner
Partner

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

Have you an "as Intervals" behind the clause?

Highlighted
Partner
Partner

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

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

Highlighted
Creator II
Creator II

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

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;

Highlighted
Partner
Partner

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

You are not getting this field in Front End?

Can you check whether you have dropped that table somewhere?

Highlighted
Creator II
Creator II

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

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!