6 Replies Latest reply: Jul 14, 2011 4:31 PM by Marc Livingston RSS

    Charting by QV Month Function showing up as numbers

      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.

        • Charting by QV Month Function showing up as numbers
          Jonathan De Deken

          Hi,

           

          In the number presentation (properties of chart) set to date.

            • Charting by QV Month Function showing up as numbers

              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.

                • Charting by QV Month Function showing up as numbers
                  Jonathan De Deken

                  HI,

                   

                  Add a sample application with retircted data so that we can have a look

                   

                  Regards

                    • Charting by QV Month Function showing up as numbers

                      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.

                      • Charting by QV Month Function showing up as numbers

                        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;

                  • Charting by QV Month Function showing up as numbers

                    I found the problem, The check box 'Continous' was checked under the Axis tab.