Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Charting by QV Month Function showing up as numbers

Hi,

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

Not applicable

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.

Not applicable

Charting by QV Month Function showing up as numbers

HI,

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

Regards

Not applicable

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.

Not applicable

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;

Not applicable

Charting by QV Month Function showing up as numbers

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

Community Browser