Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
leonardovincent
Contributor
Contributor

Multiply fields

I want to add a formula to the script below that multiples Quantity * Sales in a fourth field named Sales Revenue.  Can you help?

LOAD

    ProductName,

    Quantity,

    Sales;

1 Solution

Accepted Solutions
its_anandrjs

Write this

LOAD

    ProductName,

    Quantity,

    Sales

    Quantity * Sales as [Sales Revenue]

From Source

View solution in original post

1 Reply
its_anandrjs

Write this

LOAD

    ProductName,

    Quantity,

    Sales

    Quantity * Sales as [Sales Revenue]

From Source