Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
atkinsow
Valued Contributor II

Re: Current month data

Sunny has the right idea.  However if your data crosses years you'll also want to include Year into the calculation.

LOAD

  Date_Dash,

  Month(Date_Dash) as Month,

Year(Date_Dash) as Year,

  Program_Dash,

  UOM_Dash,

  Status_Dash,

  Ave_Cost_Dash,

  Processed_Dash

FROM [lib://AttachedFiles/OB_Summary_Data.xlsx]

(ooxml, embedded labels, table is OB_Dash_Data);



Then your expression is

=Sum({$<Status_Dash={'Completed'}, Month= {"$(=Month(Today()))"}, Year= {"$(=Year(Today()))"}>} Processed_Dash)