topic Formatting Continuous X Axis in QlikView

Formatting Continuous X Axis

bluecarbon — Wed, 12 Jul 2017 21:49:14 GMT

Hi,

I m having a continuous X axis based on field storing Dates. This x-axis field has only Weekending date stored in it and when enabling the X-axis as continuous X-axis is getting displayed the dates based on the width of the chart and not Weekending date as stored in field.

Help me how can I format Continuous X-axis field.

Thanks,

Rakul.

Re: Formatting Continuous X Axis

sunny_talwar — Wed, 12 Jul 2017 22:59:50 GMT

May be assign your formatting here

Re: Formatting Continuous X Axis

bluecarbon — Thu, 13 Jul 2017 14:28:13 GMT

Thanks for writing back,

My issue is not the Number formatting, the date field displays date in date format but it displays dates on auto interval but not Weekending dates.

I want the x-axis to be continuous and at same time controlling what dates needs to displayed. Tried with Static Min, Max and Step too but it has no effect on continuous x-axis.

Thanks,

Rakul.

Re: Formatting Continuous X Axis

sunny_talwar — Thu, 13 Jul 2017 15:01:52 GMT

Can you share a sample to try and test it out?

Re: Formatting Continuous X Axis

bluecarbon — Fri, 14 Jul 2017 15:18:38 GMT

Hi Sunny,

Please find below sample data. I want to draw a vertical reference line on few WeekEnd. To achieve this I have to enable Continuous X-Axis but after enabling it the WeekEnd are not displaying the WeekEnd but auto Date based on the chart area.

WeekEnd	Data
7/12/2015	4247
7/19/2015	7392
7/26/2015	1807
8/2/2015	2387
8/9/2015	5362
8/16/2015	1424
8/23/2015	3317
8/30/2015	3122
9/6/2015	4738
9/13/2015	1378
9/20/2015	5037
9/27/2015	1470
10/4/2015	1568
10/11/2015	3962
10/18/2015	2678
10/25/2015	4414
11/1/2015	3085
11/8/2015	3259
11/15/2015	3190
11/22/2015	4114
11/29/2015	1121
12/6/2015	4678
12/13/2015	3330
12/20/2015	4963
12/27/2015	4632
1/3/2016	1302
1/10/2016	5215
1/17/2016	1849
1/24/2016	3774
1/31/2016	2298
2/7/2016	3147
2/14/2016	3278
2/21/2016	4991
2/28/2016	1837
3/6/2016	5845
3/13/2016	1589
3/20/2016	4980
3/27/2016	3779
4/3/2016	3327
4/10/2016	4598
4/17/2016	3540
4/24/2016	4416
5/1/2016	3023
5/8/2016	1819
5/15/2016	3622
5/22/2016	4433
5/29/2016	4528
6/5/2016	3152
6/12/2016	4143
6/19/2016	4304
6/26/2016	5513
7/3/2016	1304
7/10/2016	1020
7/17/2016	6181

Re: Formatting Continuous X Axis

sunny_talwar — Fri, 14 Jul 2017 15:27:30 GMT

May be here is this one possibility

This will work only if there is space for the labels to show up... so if you make the chart smaller is probably start to not work.... But I guess that's one limitation of continuous axis