topic Re: sorting months in QlikView

sorting months

sannidhikumar — Tue, 13 Jun 2017 06:22:59 GMT

Hi All,

how to sort Year and month in order Ex: jun-2017,may-2017.

thanks ,

Re: sorting months

prma7799 — Tue, 13 Jun 2017 06:26:05 GMT

In Sort > choose dimension > in Expression > put MonthNumber as Descending..

Or please share some sample output.

Re: sorting months

sannidhikumar — Tue, 13 Jun 2017 06:44:03 GMT

PM ,

i tried but its not getting .

any other idea.

thanks

Re: sorting months

qlikview979 — Tue, 13 Jun 2017 06:44:51 GMT

Hi,

if you want like below

write the condition in sort tab and take Descending .

=match(Monthname,'jun-2017','may-2017','Mar-2017','Feb-2017',Dec-2016','Nov-2016','Oct-2016','Sep-2016')

Regards

Re: sorting months

sannidhikumar — Tue, 13 Jun 2017 06:54:38 GMT

mahesh ,

still i am getting same .

Re: sorting months

prma7799 — Tue, 13 Jun 2017 06:56:12 GMT

Share some sample app. Or share your expression and Dimensions which you using for this chart.

Re: sorting months

prma7799 — Tue, 13 Jun 2017 06:56:50 GMT

Or sort by MonthName is Sorting ...

Re: sorting months

qlikview979 — Tue, 13 Jun 2017 06:58:13 GMT

Please share the sample app

Re: sorting months

sannidhikumar — Tue, 13 Jun 2017 06:59:03 GMT

mahesh ,

due to security reasons i cant share the app .

thanks

Re: sorting months

Anil_Babu_Samineni — Tue, 13 Jun 2017 06:59:39 GMT

Would you check whether sory by Y-Value is enabled or not? Please confirm me or share image for that

Re: sorting months

prma7799 — Tue, 13 Jun 2017 07:00:46 GMT

Send some scramble data ...

Scrambling Data

Re: sorting months

sannidhikumar — Tue, 13 Jun 2017 07:03:51 GMT

QUALIFY *;

UNQUALIFY HIER_ID;

CustomerLedger_vw_QlikView:

LOAD ActualReserve,

ActualReserve_USD,

Bucket,

BusinessUnit,

BusinessUnitDescription,

CO,

Collector,

CollectorName,

CompanyCode,

COMPANYID,

ContractStatus,

ContractStatusDesc,

ContractType,

ContractTypeDesc,

CurrCode,

CustNo,

CustomerName,

Diff,

DocNo,

DocPayItem,

DocTy,

//date([Due Date],'MMM-YY') as MonthYear1,

Date(Date#([Due Date],'DD-MM-YYYY'),'MMM-YY') as MonthYear1,

year([Due Date])*100+month([Due Date]) as periodno,

//Date(Monthstart([Due Date]), 'MMM-YYYY') as MonthYear1,

[Due Date] AS Due_Date,

Month([Due Date]) & '-' & Year([Due Date]) AS MonthYear,

FX_CONV_RT,

GrossAmount,

GrossAmount_USD,

HIER_ID,

InvoiceDate,

InvoiceRef,

InvoiceRefNo,

LOB,

LOBDescription,

NationalAccount,

NationalAccountDescription,

NoOfInvoices,

NoOfUnits,

OpenAmount,

OpenAmount_UC,

OpenAmount_USD,

OpenOverDue120,

OpenOverDue180,

OpenOverDue360,

OpenOverDue60,

OpenOverDue90,

ParentCustomer_Number,

ParentCustomerName,

PaymentTerm,

PaymentTermDesc,

Pkey as PKEY,

ProjectNo,

SellRep,

SellRepName,

Tax,

Tax_USD,

TaxableOpenAmount,

TaxableOpenAmount_USD,

TotalNoOfInvoices,

TotalNoOfUnits,

TranAmt,

TranAmt_USD,

TranCurr,

TranOverDue90,

[WO G/L Date]

FROM

$(QVDPath)CustomerLedger_vw_QlikView.qvd

(qvd);

UNQUALIFY *;

Re: sorting months

prma7799 — Tue, 13 Jun 2017 07:08:55 GMT

Hi Pradeep ,

We don't want script we need sample application with scrambling data ...

Go to >> Setting >> Document properties >> Scrambling

Re: sorting months

Anil_Babu_Samineni — Tue, 13 Jun 2017 07:10:10 GMT

May be use at last Order By Date(Date#([Due Date],'DD-MM-YYYY'),'MMM-YY') ASC;

Re: sorting months

jonathandienst — Tue, 13 Jun 2017 07:30:28 GMT

If you convert the dates from strings into numeric date values, then you can sort them numerically. Load them something like this:

LOAD

...

Year,

month,

Date#(month & '-' & Year, 'MMM-yyyy') as YearMonth,

...

Adjust to your environment and requirements.

If you need more specific help, you will need to provide more information and a sample qvw file.

Re: sorting months

sannidhikumar — Tue, 13 Jun 2017 08:35:15 GMT

Jonathan ,

i tried but still the same i am getting .

any other idea.

thanks ,

Re: sorting months

sannidhikumar — Tue, 13 Jun 2017 08:45:22 GMT

Anil ,

i am using the same in the back end .

thanks,

Re: sorting months

stevedark — Tue, 13 Jun 2017 13:45:31 GMT

Where is your screenshot from, is this a PivotTable we are looking at?

Sorting can be a bit strange in pivots, but you should be able to get it to behave.

Right click the chart and then click Properties.

Select the Sort tab.

Ensure that Y Value is not clicked for any dimension (this will break things)

Click the Month dimension

Ensure that Numeric Value is ticket - and nothing else is selected

Click OK

Hopefully that will do it, if not...

Add a ListBox to your app with the Month field in it, and then advise whether that ListBox sorts correctly, and whether the dates are left or right aligned.

Steve

Re: sorting months

Frank_Hartmann — Tue, 13 Jun 2017 14:28:39 GMT

this thread might be helpful for frontend solution using Mod function:

Re: Current Year vs Previous Year Sort Order

hope this helps