Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

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
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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: 
Not applicable
‎2010-08-04 05:20 AM

Create an Expression

Hey guys

I need to create an expression called Sales by using the following fields:

Quantity

Price

Discount

I already know i need to take Quantity and multiply it by the price and minus the discount. I can do that manually in expressions but i need to create a set expression and it may not be done by using a variable. Can anyone help me create it in the script or something?

Please, any ideas are welcome

5,880 Views
0 Likes
11 Replies
Not applicable
‎2010-08-05 05:42 AM
Author

In response to Miguel_Angel_Baeyens

im sorry but i dnt understand???

162 Views
0 Likes
Miguel_Angel_Baeyens
Employee
Employee
‎2010-08-05 05:50 AM

In response to

Blaze,

Your "ProductID" field exists in the two tables you are loading, "SalesOrderDetail" and "Product". The error ODBC is throwing and you posted above means that when you do the SQL query, and one fieldname exists in more than one table, you must specify the name of the table from where you want to get that field.

Take into account that the ODBC passes the same statement you have written, so if it has errors, the query won't be executed. I guess that you will get the same error if you perform the same query in your SQL console.

Hope that helps.

162 Views
0 Likes