Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
reddwarfcrew
Contributor II
Contributor II
‎2017-10-16 03:43 PM

Calculated field in script

Hi,

I have 2 SQL Select statements from an oracle db in a script.

I'd like to create a calcuated field based on values from each of the 2 seperate SQL scripts.  I know how to do this as a calculated dimension, but I'd like to use it in multiple objects in the report, so would prefer to put it into the load or have as some sort of global calculated dimesion.

Any ideas?

Thanks

2,143 Views
0 Likes
10 Replies
reddwarfcrew
Contributor II
Contributor II
‎2017-10-17 01:40 PM
Author

In response to JaMajka1

Finally sussed the problem.  For some reason, the script didn't like the field name having an _ in it.  I renamed the field to remove the _ and it worked!!

184 Views
0 Likes