topic Re: Show only Friday date labels in Continuous X-axis? in QlikView

Show only Friday date labels in Continuous X-axis?

praveenpurush6 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,
I have a chart with a continuous x-axis in which I would like to show only the Friday dates in the x-axis labels.

For example, for the below table I need to show labels only for 1/5/2018 and 1/12/2018.

Dates Values

1/1/2018	13
1/2/2018	5
1/3/2018	36
1/4/2018	23
*1/5/2018*	18
1/6/2018	46
1/7/2018	48
1/8/2018	14
1/9/2018	21
1/10/2018	33
1/11/2018	28
*1/12/2018*	25
1/13/2018	28
1/14/2018	37
1/15/2018	15
1/16/2018	11
1/17/2018	47

Any help?

Thanks!

Re: Show only Friday date labels in Continuous X-axis?

shiveshsingh — Mon, 26 Mar 2018 08:35:02 GMT

may be this dimension.

if(WeekDay(Dates)='Fri',Dates)

Re: Show only Friday date labels in Continuous X-axis?

bramkn — Mon, 26 Mar 2018 08:42:28 GMT

This should work, and It might even be better to add a field in script with this if and use that field as the dimension.

Re: Show only Friday date labels in Continuous X-axis?

shiveshsingh — Mon, 26 Mar 2018 08:51:25 GMT

Yes, that can also help.

Re: Show only Friday date labels in Continuous X-axis?

MarcoWedel — Mon, 26 Mar 2018 09:03:27 GMT

Does it have to be a continuous dimension axis?

I guess this requirement would be easier implemented using a discrete axis.

regards

Marco

Re: Show only Friday date labels in Continuous X-axis?

adityaakshaya — Mon, 26 Mar 2018 09:04:02 GMT

Hi Praveen,

You can limit you values using expression too.

if(WeekDay(Dates)='Fri',sum(Values))

Regards,

Akshaya

Re: Show only Friday date labels in Continuous X-axis?

praveenpurush6 — Mon, 26 Mar 2018 13:09:06 GMT

Hi Akshaya,

Doing this will filter down the dates to Friday only right?

I need to show Friday dates on labels only.

One option I can think off is having the first date as a Friday date and keep 7 or 14 in the static step field.

Re: Show only Friday date labels in Continuous X-axis?

shiveshsingh — Mon, 26 Mar 2018 17:14:49 GMT

What issue are u getting in calculated dimension?

Re: Show only Friday date labels in Continuous X-axis?

tamilarasu — Tue, 27 Mar 2018 02:32:58 GMT

Hello Praveen,

May be this?

=Dual(If(WeekDay(Date)='Fri',Date,''),Date)

Re: Show only Friday date labels in Continuous X-axis?

praveenpurush6 — Wed, 28 Mar 2018 05:54:44 GMT

Thanks for replies, everyone.

I replaced the minimum date as a Friday date and added a static step value...now everything looks fine.

Thanks again.