Reference Line in Combo chart

darkshadow91223 — Fri, 15 Jun 2018 20:17:13 GMT

Hi everyone,

I got this situation,

Need to draw a vertical line in my current week (i.e. second image), my x-axis is a string filed name: Period. I'ven trying with reference lines and clicking in Axes, Continuous but i recive the message "no numeric values on x-axis".

And i have this formula to know wich is current week:

=if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W1','Week 1',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W2','Week 2',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W3','Week 3',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W4','Week 4',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W5','Week 5',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W6','Week 6',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W7','Week 7',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W8','Week 8',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W9','Week 9',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W10','Week 10',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W11','Week 11',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W12','Week 12',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W13','Week 13',

if(('W' & num((date(today())-$(vQuarterDate)+1)/7,'#0'))='W14','Week 13-1'))))))))))))))

vQuarterDate:

if(num(Month(Today()))=5 or num(Month(Today()))=6 or num(Month(Today()))=7,Year(Today())&'-05-01',

if(num(Month(Today()))=8 or num(Month(Today()))=9 or num(Month(Today()))=10,Year(Today())&'-08-01',

if(num(Month(Today()))=2 or num(Month(Today()))=3 or num(Month(Today()))=4,Year(Today())&'-02-01',

if(num(Month(Today()))=11 or num(Month(Today()))=12 or num(Month(Today()))=1,Year(Today())&'-11-01'))))

Thanks in advance!

Re: Reference Line in Combo chart

Frank_Hartmann — Sat, 16 Jun 2018 10:40:53 GMT

Do you have continous axis enabled?

Re: Reference Line in Combo chart

darkshadow91223 — Sat, 16 Jun 2018 14:07:30 GMT

Yes, and i recive the message "no numeric values on x-axis". due to my string dimension

Re: Reference Line in Combo chart

Frank_Hartmann — Sat, 16 Jun 2018 15:15:12 GMT

can you share the qvw? Maybe scramble the sensitive fields (settings-->document properties --> Scrambling)

topic Re: Reference Line in Combo chart in QlikView

Reference Line in Combo chart

Re: Reference Line in Combo chart

Re: Reference Line in Combo chart

Re: Reference Line in Combo chart