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

Question

roronoa zoro Jan 30, 2012 10:03 PM

Hi,

Is this possible with Qlikview:

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

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

Question

roronoa zoro Jan 31, 2012 12:02 AM (in response to roronoa zoro)

up!
Like Show 0 Likes (0)

Actions
- Question
  
  Tom Oxton Jan 31, 2012 6:34 AM (in response to roronoa zoro)
  
  Hi Mars,
  
  Are you looking to do this specifically in the load script?
  
  I know it can be done in Qlik rather easily if you do it on a pivot table with field1 fielde field3 making up the dimensions and the expression being the sum(amount) from Sales where date >= MonthEnd(date)).
  
  I am not sure how you would do it in the load script.
  
  Tom
  
  Like Show 0 Likes (0)
  
  Actions