Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Missing Field Value

Hello Everyone,

I am having a problem, I am trying to alias these fields as you can see here:

Screenshot (15).png

But I get this error:

Screenshot (16).png

Please can someone tell me what the issue is?

Best wishes,

Alison

16 Replies
Not applicable
Author

Hi Arvind,

Thank you.

I have tried your solution.

All work well except for here:

Screenshot (17).png

Screenshot (18).png

Why does this happen?

Best,

Alison

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Alison,

It shows It doesn't  get income table.

Thanks,

Arvind Patil

Not applicable
Author

Hi Arvind,

Yes, I know that but why is it showing that? The income table is there.

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Alison,

Maybe there is the issue in Date format kindly use:


num(Date([Income Date],' ------here write format of your date field(DD/mm/YYYY)----') ) as [Income Date]

Thanks,

Arvind Patil

Not applicable
Author

Hi Arvind,

I have given this a try but I am still getting the same issue unfortunately.

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Alison,

Please give Sample QVW.

Thanks,

Arvind Patil

Not applicable
Author

Of course, here it is.