topic Re: Line graph help in QlikView

Line graph help

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

Trying to create a line graph with the dimensions as months of the current year.

values being the result of the data from every month.

currently I have set the graph to this:

Dimension:

=[Date.autoCalendar.Month]

Expression:

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

Script:

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

The results I have for Jun is 130512 and July is 19286, but I need to show all 12 months. even though jan-may returns a 0

Re: Line graph help

Gysbert_Wassenaar — Mon, 10 Jul 2017 17:37:50 GMT

Disable the Suppress Zero-values option on the Presentation tab and add + sum({1}0) to your expression

Re: Line graph help

joshrussin — Mon, 10 Jul 2017 18:51:23 GMT

these are the options under presentation

Re: Line graph help

sergio0592 — Mon, 10 Jul 2017 19:01:40 GMT

I think you are in Sense, but gwassenaar refers to QlikView.

Re: Line graph help

joshrussin — Mon, 10 Jul 2017 19:07:49 GMT

I am using qlik sense

Re: Line graph help

rubenmarin — Mon, 10 Jul 2017 20:32:26 GMT

Hi Joshua, you only have data for those consecutive months? In that case you'll need to create a calendar with dates at least for a year.

Calendar:

LOAD

TempDate as Date_Dash,

Month(TempDate ) as Month,

// Other fields, remove from 'Script' table and set here;

LOAD

Date(MinDate + IterNo()) as TempDate

While MinDate + IterNo() <= MaxDate;

// or "AddMonths(MinDate, IterNo())" to generate only months

LOAD

YearStart(Min(FieldValue('Date_Dash', RecNo()))) as MinDate,

YearEnd(Max(FieldValue('Date_Dash', RecNo()))) as MaxDate

AutoGenerate FieldValueCount('Date_Dash');

Re: Line graph help

joshrussin — Wed, 12 Jul 2017 16:01:08 GMT

I reckon I was just overthinking it. I figured it out.

Dimension:

Month

Expression:

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