Extracting data from individual months

joshrussin — Wed, 25 Nov 2020 16:16:04 GMT

I need to figure out a way to pull the total processed for each month.

LOAD

Date_Dash,

Month(Date_Dash) as vLM,

Year(Date_Dash) as vLY,

MakeDate(year(Date_Dash)) as vCY,

MakeDate(month(Date_Dash)) as vCM,

Program_Dash,

UOM_Dash,

Status_Dash,

Ave_Cost_Dash,

Processed_Dash

Currently have this in my script to attempt the MakeDate for the month and year.

Attempting this equation to retrieve the data for a specific month in the current year.

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

I passed the 7 to try and retrieve July's data. Just returns a 0.

Any suggestions?

Re: Extracting data from individual months

sunny_talwar — Fri, 07 Jul 2017 19:24:32 GMT

Try like this

LOAD

Date_Dash,

Month(Date_Dash) as Month,

Num(Month(Date_Dash)) as MonthNum,

Year(Date_Dash) as Year,

MakeDate(year(Date_Dash)) as vCY,

MakeDate(month(Date_Dash)) as vCM,

Program_Dash,

UOM_Dash,

Status_Dash,

Ave_Cost_Dash,

Processed_Dash

and then this

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

Note: I have changed your field names from vblahblah to Month and Year because v is usually used for variables. By using v as a field name, you are probably going to confuse other developers and/or people on the community making them think that vblahblah is a variable.

topic Re: Extracting data from individual months in QlikView

Extracting data from individual months

Re: Extracting data from individual months