Dimension interval

[ali_hijazi]

hello

I have two expressions on a line chart

on the x-axis I want to show values that range from 0 till 12

How can I attain this?

Please advise

[jonathandienst]

HI

How about:

    =(Year(DefectDate) - Year(SellDate)* 12 + (Month(DefectDate) - Month(SellDate))

    =(Year(FixDate) - Year(SellDate)* 12 + (Month(FixDate) - Month(SellDate))

It would be simpler if QV had a DateDiff function like SQL:)

HTH

Jonathan