topic Question in QlikView

Question

Tue, 31 Jan 2012 02:51:15 GMT

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

Tue, 31 Jan 2012 05:02:10 GMT

up!

Question

oxtontom — Tue, 31 Jan 2012 11:34:10 GMT

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