Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
up!
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