Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For some reason when I am charting by a QV Month(orderdate) field, (Set in the Select Statement under LOAD), it shows up as a number. The same field when added to a list box shows up as the 3 letter month name. I have an almost identical field in another table (invoicedate) that I am charting by that shows the correct 3 letter month name.
How do I fix this? I do not see any differences between the charts, or the fields but they display differently.
Hi,
In the number presentation (properties of chart) set to date.
When I do this it displays as 1/1/1900 1/3/1900 1/7/1900 ect. This is not a date field anymore because I converted it to a month field.
HI,
Add a sample application with retircted data so that we can have a look
Regards
I am new to QV (only have been working in it for about 2 weeks) so I have no idea how to do that. Also I think it goes against my companies confidentiality policy for the data.
How ever this is the Selection statement I am using:
LOAD
company & '-' & custnum as companycust,
company & '-' & ordernum as companyordernum,
company & '-' & ordernum as companyord,
company,
Month(orderdate) as Monthord,
Year(orderdate) as Yearord,
Date(orderdate,'MM/DD/YYYY') as OrdDate,
if(YEAR(orderdate)=Year(today()),orderamt) as Currentyear,
if(YEAR(orderdate)=(Year(today())-1),orderamt/.8) as Goal,
openorder,
orderamt,
If(orderamt<25000,'1. Under 25K',If((orderamt>=25000 and orderamt<50000),'2. 25K–50K',If((orderamt>=50000 and orderamt<100000),'3. 50K to 100K',If((orderamt>=100000 and orderamt<200000),'4. 100K to 200K',If((orderamt>=200000 and orderamt<300000),'5. 200K to 300K',If((orderamt>=300000 and orderamt<400000),'6. 300K to 400K',If((orderamt>=400000 and orderamt<500000),'7. 400K to 500K',if(orderamt>=500000,'8. Over 500K'))))))))as OrderLvl,
ordernum,
requestdate;
SQL SELECT
company,
custnum,
orderdate,
openorder,
orderamt,
ordernum,
requestdate
FROM epicor904.dbo.orderhed
where voidorder='0';
Load
company & '-' & ordernum as companyord,
company & '-' & prodcode as companyprod,
company & '-' & partnum as companypart,
company & '-' & ordernum & '-' & orderline as companyjobprod,
company & '-' & ordernum & '-' & orderline as companyorderline,
company & '-' & ordernum & '-' & orderline as companyshipord,
extpricedtl,
If(openline=1,extpricedtl) as OpenAmt,
If(openline=0,extpricedtl) as ClosedAmt,
linedesc,
openline,
orderline,
orderqty,
partnum,
prodcode;
SQL SELECT
company,
extpricedtl,
linedesc,
openline,
orderline,
ordernum,
orderqty,
partnum,
prodcode
FROM epicor904.dbo.orderdtl
where voidline='0';
LOAD
company & '-' & partnum as companypart,
company & '-' & classid as companyclass;
SQL SELECT
company,
partnum,
classid
FROM epicor904.dbo.part;
LOAD
company & '-' & classid as companyclass,
description as Class;
SQL SELECT
company,
classid,
description
FROM epicor904.dbo.partclass;
LOAD
company & '-' & prodcode as companyprod,
description as Product;
SQL SELECT
company,
description,
prodcode
FROM epicor904.dbo.prodgrup;
LOAD
company & '-' & custnum as companycust,
company & '-' & territoryid as companyter,
company & '-' & groupcode as companygroup,
custnum,
custid,
Month(estdate) as EstMonth,
Year(estdate) as EstYear,
Date(estdate) as EstDate,
name,
city,
customertype,
groupcode,
state,
country,
salesrepcode;
SQL SELECT
company,
custid,
custnum,
estdate,
name,
city,
customertype,
groupcode,
state,
country,
salesrepcode,
territoryid
FROM epicor904.dbo.customer;
LOAD
company & '-' & territoryid as companyter,
territorydesc;
SQL SELECT
company,
territoryid,
territorydesc
FROM epicor904.dbo.salester;
LOAD
company & '-' & ordernum & '-' & orderline as companyjobprod,
company & '-' & jobnum as companyjob;
SQL SELECT
company,
jobnum,
ordernum,
orderline
FROM epicor904.dbo.jobprod;
LOAD
company & '-' & jobnum as companyjob,
company & '-' & schedcode as companysch;
SQL SELECT
company,
jobnum,
schedcode
FROM epicor904.dbo.jobhead;
LOAD
company & '-' & schedcode as companysch,
description as SchedulePriority;
SQL SELECT
company,
schedcode,
description
FROM epicor904.dbo.SchedPri;
LOAD
company & '-' & groupcode as companygroup,
groupdesc as CustomerGroup;
SQL SELECT company,
groupcode,
groupdesc
FROM epicor904.dbo.custgrup;
LOAD
if(isnull(invoicenum),'Not Invoiced','Invoiced') as Status,
applydate,
closeddate,
company & '-' & invoicenum as companyinv,
docinvoiceamt,
docinvoicebal,
duedate,
invoiceamt,
invoicebal,
invoicedate,
Month(invoicedate)as invoicemonth,
Year(invoicedate) as invoiceyear,
Month(invoicedate) & '-' & Year(invoicedate) as invoicemonthyear,
invoicenum,
posted,
shipdate as invoiceshipdate;
SQL SELECT applydate,
closeddate,
company,
docinvoiceamt,
docinvoicebal,
duedate,
invoiceamt,
invoicebal,
invoicedate,
invoicenum,
ordernum,
posted,
shipdate
FROM epicor904.dbo.invchead
WHERE posted=1;
LOAD
company & '-' & invoicenum & '-' & invoiceline as companymsc,
company & '-' & ordernum & '-' & orderline & '-' & orderrelnum & '-' & packnum & '-' & packline as companyshipinv,
company & '-' & invoicenum as companyinv,
discount,
discountpercent,
docextprice,
docunitprice,
extprice,
invoiceline,
packnum as invpack,
sellingorderqty,
sellingshipqty;
SQL SELECT company,
discount,
discountpercent,
docextprice,
docunitprice,
extprice,
invoiceline,
invoicenum,
orderline,
ordernum,
orderrelnum,
packnum,
packline,
sellingorderqty,
sellingshipqty
FROM epicor904.dbo.invcdtl;
LOAD
company & '-' & invoicenum & '-' & invoiceline as companymsc,
misccode,
description as MiscDescription,
miscamt;
SQL SELECT company,
invoicenum,
invoiceline,
misccode,
description,
miscamt
FROM epicor904.dbo.invcmisc;
LOAD
company & '-' & shipviacode as companyshipvia,
company & '-' & packnum as companypack,
deliverytype,
invoiced as Packinvoiced,
packnum,
readytoinvoice,
shipcomment,
shipdate,
Month(shipdate) as Shipmonth,
Year(shipdate) as Shipyear,
shipstatus,
shipviacode;
SQL SELECT company,
deliverytype,
invoiced,
packnum,
readytoinvoice,
shipcomment,
shipdate,
shipstatus,
shipviacode
FROM epicor904.dbo.shiphead;
LOAD
company & '-' & packnum as companypack,
company & '-' & ordernum & '-' & orderline & '-' & orderrelnum & '-' & packnum & '-' & packline as companyshipinv,
company & '-' & ordernum & '-' & orderline as companyshipord,
packline,
invoiced as Lineinvoiced;
SQL SELECT
company,
invoiced,
orderline,
ordernum,
orderrelnum,
packline,
packnum
FROM epicor904.dbo.shipdtl;
LOAD
company & '-' & shipviacode as companyshipvia,
description as ShippedVia;
SQL SELECT company,
description,
shipviacode
FROM epicor904.dbo.shipvia;
I found the problem, The check box 'Continous' was checked under the Axis tab.