topic Re: Line chart break in QlikView

Line chart break

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have the data on monthly level.

xSales are not availabale from September.But ySales are there for entire year.

I have created a line chart with two lines with xSalesAmount and ySalesAmount.

As data is not there for xSalesAmount from September, want to show ySalesAmount to continue the line.

My requirement is ySalesAmount should start from August.

August ySalesAmount =August xSalesAmount

Please help me.

Re: Line chart break

sunny_talwar — Fri, 07 Oct 2016 02:30:33 GMT

Are you looking to get this?

Expression:

=If(Len(Trim(if(GetSelectedCount(Year)=0,

IF(Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD-MMM-YY') & '<=' & Date(Max(Date), 'DD-MMM-YY'))"},[Month Name]=, Month=, Year>}xSales),

Rangesum(Sum({< Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD-MMM-YY') & '<=' & Date(Max(Date), 'DD-MMM-YY'))"},[Month Name]=, Month=, Year>}ySales),Above("xSalesAmount"))),

IF(Sum({< Date =,[Month Name]=, Month=>}xSales),

Rangesum(Sum({< Date = ,[Month Name]=, Month=>}xSales),Above("xSalesAmount")))

))) = 0,

RangeSum(Above(if(GetSelectedCount(Year)=0,Sum({<Year={'$(=max(Year))'},Date={'<=$(=vMaxXSalesAmount)'},[Month Name], Month>}xSales) + Sum({<Year={'$(=max(Year))'},Date={'>$(=vMaxXSalesAmount)'},[Month Name], Month>}ySales)

,Sum({<Date={'<=$(=vMaxXSalesAmount)'},[Month Name], Month>}xSales) + Sum({< Date={'>$(=vMaxXSalesAmount)'},[Month Name], Month>}ySales)

), 0, RowNo())),

if(GetSelectedCount(Year)=0,

IF(Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD-MMM-YY') & '<=' & Date(Max(Date), 'DD-MMM-YY'))"},[Month Name]=, Month=, Year>}xSales),

Rangesum(Sum({< Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD-MMM-YY') & '<=' & Date(Max(Date), 'DD-MMM-YY'))"},[Month Name]=, Month=, Year>}ySales),Above("xSalesAmount"))),

IF(Sum({< Date =,[Month Name]=, Month=>}xSales),

Rangesum(Sum({< Date = ,[Month Name]=, Month=>}xSales),Above("xSalesAmount")))

))

Re: Line chart break

Fri, 07 Oct 2016 02:48:18 GMT

Hi Sunny,

Thanks for the reply.

I want the ySalesAmount like this:

Re: Line chart break

jagan — Fri, 07 Oct 2016 03:06:50 GMT

Hi,

Is it ok to change the color of the line for X and Y values? It is a good option and you will get the line continuously and the expression will be simple.

Please find attached file for solution.

Regards,

Jagan.

Re: Line chart break

jagan — Fri, 07 Oct 2016 03:07:56 GMT

Hi,

I did the following

Expression: =Sum({<Date={'<=$(=vMaxXSalesAmount)'}>}xSales) + Sum({<Date={'>$(=vMaxXSalesAmount)'}>}ySales)

Background Expression: If(Date <= vMaxXSalesAmount, RGB(0,255,0), RGB(0, 0, 255))

Regards,

Jagan.