Charting by QV Month Function showing up as numbers

Thu, 14 Jul 2011 17:58:51 GMT

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

Thu, 14 Jul 2011 18:21:45 GMT

Hi,

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

Charting by QV Month Function showing up as numbers

Thu, 14 Jul 2011 18:27:55 GMT

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

Thu, 14 Jul 2011 19:01:22 GMT

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

Thu, 14 Jul 2011 19:12:01 GMT

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

Thu, 14 Jul 2011 19:12:57 GMT

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

Thu, 14 Jul 2011 20:31:12 GMT

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

topic Charting by QV Month Function showing up as numbers in QlikView

Charting by QV Month Function showing up as numbers

Charting by QV Month Function showing up as numbers

Charting by QV Month Function showing up as numbers

Charting by QV Month Function showing up as numbers

Charting by QV Month Function showing up as numbers

Charting by QV Month Function showing up as numbers

Charting by QV Month Function showing up as numbers