# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor II

## Bar chart with conditionnal reference line

Hello,

I have a bar chart with Year and Weeks as dimentions (weeks first) and number of sells as measure and i wanted to know if it was possible to have a reference "line" to show each week's sells objectives.

A combo chart can do it with a second measure but i lose the second dimension of the bar chart, and i don't want that.

Thanks !

----------

Bonjour,

J'ai un graphique en barres avec comme dimensions années et semaines (les semaines en premier) et le nombre de ventes comme mesure. J'aimerais savoir si c'était possible d'ajouter une ligne de référence qui montre les objectifs de vente de chaque semaine.

Dans le graphique combiné la seconde mesure permet de faire ça mais je perdrais du coup la dimension année du graph en barres et il doit rester.

Merci d'avance !

Tags (2)
5 Replies
Valued Contributor

## Re: Bar chart with conditionnal reference line

Yes add another Mesure for a reference line and change it from bar to line

Contributor III

## Re: Bar chart with conditionnal reference line

and replace your dimensions Year and Month by one dimension Year-Month...otherwise, indeed, not something psosible in the standard objects of Qlik Sense.

Contributor

## Re: Bar chart with conditionnal reference line

Hi Gus - you are correct - the reference line add-on fx expression - can be used to create a calculated, dynamic value to create a dynamic line as per the conditions defined in the expression. If you want to use a line as an actual trend line, you must use that formula you showed, as an expression in another measure.

I assume you got that example from here How to add lineal trend in Qlik sense or here: Re: How to add lineal trend in Qlik sense

Let me know if you have any other questions.

Regards,

Mike Tarallo

Qlik

New Contributor II

## Re: Bar chart with conditionnal reference line

OK, thanks.

I don't think i can merge the 2 dimensions, it will not be clear enough. With 52 weeks each year, the chart would be too long.

Do you know of an extension that would do the trick?

New Contributor II

## Re: Bar chart with conditionnal reference line

Hello guys,

I can't use your suggestions of the reference line as a measure since i have a simple bar chart and not a combo chart. And the client want to keep his sorting by weeks and year.

Here is what i have right now :

The goal was to add a line which would show each week's goals that the client could change. Kinda like so :

It's not possible with standard QlikSense (thanks Mikael) so does any of you know an extension that would do the trick?