topic Re: Display text label for expression in a bar chart in QlikView

Display text label for expression in a bar chart

Mon, 08 Feb 2016 20:54:13 GMT

Newbie question here. I have a simple bar chart that shows the use cases (dimension) by quarter/year. I can successfully get the basics of the chart the way the user wants by using the year concatenated with quarter as my expression, but the expression labels then shows as '20171' for example whereas I would like to show it as 'Q1 2017'. Is this possible?

Re: Display text label for expression in a bar chart

sunny_talwar — Mon, 08 Feb 2016 21:24:19 GMT

Try this as the expression for label:

'Q' & Month(Date) & ' ' & Year(Date)

'Q' & Ceil(Month(Date)/3) & ' ' & Year(Date)

Re: Display text label for expression in a bar chart

swuehl — Mon, 08 Feb 2016 21:27:38 GMT

='Q'& QuarterField & ' ' & YearField

Re: Display text label for expression in a bar chart

Mon, 08 Feb 2016 21:38:33 GMT

I must be doing something wrong as I tried that previously (and again now), and my chart just shows 'No data to display' when I use that as my expression.

Here's a visual of what I have and what I'm going for.

Re: Display text label for expression in a bar chart

sunny_talwar — Mon, 08 Feb 2016 21:44:29 GMT

May be try this as your calculated dimension instead of [use case]:

Dual('Q' & Right([use case], 1) & ' ' & Left([use case], 4), [use case])

Re: Display text label for expression in a bar chart

swuehl — Mon, 08 Feb 2016 21:47:05 GMT

Missed that you are using an expression.

I don't think you will easily get a text representation at y-axis, but for mouse over, you can try

=Dual( 'Q'& QuarterField & ' ' & YearField, Makedate(YearField, QuarterField*3-2) )

Re: Display text label for expression in a bar chart

swuehl — Mon, 08 Feb 2016 21:55:09 GMT

What should work is using a an expression that returns a date:

=Makedate(YearField, QuarterField*3-2)

Then set the number format in Number tab to date and use some format code like MMM YYYY

No format code for quarters, AFAIK.

Re: Display text label for expression in a bar chart

Tue, 09 Feb 2016 13:52:42 GMT

So it is pretty limited it appears. Thanks swuehl, I will use your suggestions to get a little closer to what they wanted.