Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

6 Replies
Not applicable
Author

Hi,

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

Not applicable
Author

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.

Not applicable
Author

HI,

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

Regards

Not applicable
Author

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.

Not applicable
Author

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;

Not applicable
Author

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