Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

2 Replies
Not applicable

Question

up!

oxtontom
Not applicable

Question

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