topic Limit Line Chart Labels in QlikView

Limit Line Chart Labels

ysiroong — Wed, 12 Feb 2014 21:41:58 GMT

I want to create a chart that contains all 365 days of the year, but only show the labels for the first day of the month (example below). Is this possible?

Re: Limit Line Chart Labels

MK_QSL — Wed, 12 Feb 2014 21:56:02 GMT

Create Two Expressions

Example:

First Expression : SUM(Sales)

Here Tick Line in Expression Tab and Untick Value on Data Points

2nd Expression : If(Month = 'Jan' SUM(Sales))

Here Untick Line in Expression Tab and Tick Value on Data Points...

Re: Limit Line Chart Labels

Wed, 12 Feb 2014 21:57:53 GMT

This might not be apt workaround for you, but you can use vertical axes to mark / differentiate months

Re: Limit Line Chart Labels

ysiroong — Fri, 14 Feb 2014 13:11:43 GMT

No. I don't need to display 2 expressions. You can ignore the black line on the chart. I need the chart to display the red line where we can see the different data points for every day of the year, but only show the months as the x-axis label.

Re: Limit Line Chart Labels

jonathandienst — Fri, 14 Feb 2014 13:39:30 GMT

For the expression, click the + sign and enter an expression to return 1 on the first day of the month in the "Show Values" option.

eg - assuming "Date" is the date field and the chart dimension:

=If(Date = MonthStart(Date), 1, 0)

Make sure the'Values on Data Points' is cleared.

HTH

Jonathan

Re: Limit Line Chart Labels

ysiroong — Fri, 14 Feb 2014 13:52:08 GMT

Unless I'm doing something wrong, it looks like this adds the point value on the chart for the first of the month. I don't want to show that. I need the x axis to only show the single label for each month, instead of every single day of the year.

Right now, my chart has 365 data points. The x axis shows 1/1/2013 1/2/2013 1/3/2013 all the way to 12/31/2013. I only want it to show Jan Feb Mar....Nov Dec, but I need the chart to still the data points for each day. Just like in the image I attached.