topic Re: Multiple entries on Axis label in QlikView

Multiple entries on Axis label

peterderrington — Mon, 11 Nov 2019 16:56:37 GMT

Hi,

I have the graph below which shows the dimension (Week Number) and then with the month relative to that week number displaying as an expression but just as Text on Axis.

Obviously there are a couple of times that show as "-" due to that week crossing over two months. Is it possible to show it as "May/June" for example?

Thanks,

Peter

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 02:59:53 GMT

I can get this but not as expected in May/Jun result.

But this will not have nulls in your dimension.

In dimension, try using calculated dimension with the formula:

Month&CHR(10)&Week

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 03:08:56 GMT

In QS, create a master dimension and insert the expression above.

Re: Multiple entries on Axis label

peterderrington — Tue, 12 Nov 2019 09:26:40 GMT

I don'y know whats going on but my computer seems to be classifying everything as the solution when actually we're not there yet.

I initially got a little red squiggly line under the 'week' section of that expression, so i altered it to the dimension of [Week Number] which is the original dimension but that doesn't alter whats showing.

Any ideas?

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 09:55:10 GMT

You have a sample app?

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 10:01:12 GMT

Did you drag the master dimension into the chart?

Re: Multiple entries on Axis label

peterderrington — Tue, 12 Nov 2019 10:06:40 GMT

Sorry, not quite sure what you mean.

Attached is an example of the chart.

Thanks

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 10:26:01 GMT

Refer attached as reference.

Re: Multiple entries on Axis label

peterderrington — Tue, 12 Nov 2019 10:33:12 GMT

So close....

we just seem to be missing the numbers for the week underneath - you can see the top of something that i'm presuming is the numbers.

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 10:40:31 GMT

Where is the missing numbers?

I can see the numbers of weeks are populated:

If you are referring to the Week Number label, refer attached.

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 10:42:40 GMT

Or maybe try scrolling down the right scrollbar, your chart size is too big to be viewed in PC screen.

Re: Multiple entries on Axis label

peterderrington — Tue, 12 Nov 2019 10:45:42 GMT

I'm not getting a righthand scroll bar.

I just see the image below.......

Odd.

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 11:03:17 GMT

Can you screenshot the entire QV app?

Re: Multiple entries on Axis label

peterderrington — Tue, 12 Nov 2019 11:41:46 GMT

Re: Multiple entries on Axis label

Arthur_Fong — Tue, 12 Nov 2019 12:05:30 GMT

What's your QV version?

Mine > 2017 November SR8

Re: Multiple entries on Axis label

peterderrington — Wed, 13 Nov 2019 09:22:00 GMT

Sorry for the delay - i was out of the office.

I'm using QlikView April 2019 SR1 Version 12.40.20100.0

Re: Multiple entries on Axis label

Arthur_Fong — Wed, 13 Nov 2019 09:28:28 GMT

Maybe you can log a case to support team and diagnose what is causing the problem.

Re: Multiple entries on Axis label

peterderrington — Wed, 13 Nov 2019 09:49:28 GMT

Thanks, i'll give that a try.

Re: Multiple entries on Axis label

Arthur_Fong — Wed, 13 Nov 2019 10:09:02 GMT

You can try this sample app also:

I added week(Date,6,0), which means week is computed starting from Sunday(6), without broken weeks(0).

This will not generate duplicated weeks.

Eg: Week of 22 comprises of both May and June.

Refer attached as reference.

Thanks and regards,

Arthur Fong