2 Replies Latest reply: Jan 31, 2012 6:34 AM by Tom Oxton RSS

    Question

      Hi,

       

      Is this possible with Qlikview:

       

      Select field1, field2, field 3 = (Select sum(amount) from Sales where date >= MonthEnd(date)) From Budgets

       

      or

       

      Load *,

            if (Date>=MonthEnd, call select Statement, amount) as new_field

      From Source

       

      Select Statement = Select field1, field2, field 3 = (Select sum(amount) from Sales where date >= MonthEnd(date)) From Budgets