Question

[#1]

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

[#2]

up!

[oxtontom]

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