topic Re: Concat and Sort Year-Month in QlikView

Concat and Sort Year-Month

Wed, 25 Nov 2020 16:16:04 GMT

Hi every one

i need to join two field Year and Month

my year is shamsi year

and my month is 'فروردین - اردیبهشت - خرداد - تیر - مرداد - شهریور - مهر - آبان ـ آذر - دی - بهمن ـ‌اسفند'

after concatenate i have one field like "1394فروردین"

i want when i choose 2 year, i see in my dimension from first month of max year up to last month of max year

and then first month of previous year up to last month of previous year.

sort is like below :

1394 فروردین

1394 اردیبهشت

1394 خرداد

1394 تیر

1394 مرداد

1394 شهریور

1393 فروردین

1393 اردیبهشت

1393 خرداد

...

please help me

Best Regards

Hamide

Re: Concat and Sort Year-Month

hic — Tue, 19 Jul 2016 11:31:37 GMT

I suggest you take a look at the files posted on Non-Gregorian calendars. Among them is a script that generates a Shamsi (Persian) calendar, including a field "YearMonth".

The script uses the latinized Farsi month names, but it is easy to change it to use Farsi script. Just change

// Farsi as MonthName,

[Farsi Latin script] as MonthName,

Farsi as MonthName,

// [Farsi Latin script] as MonthName,

HIC

Re: Concat and Sort Year-Month

ramasaisaksoft — Tue, 19 Jul 2016 11:43:41 GMT

Hi Ghadimabadi,

Try to sort this column/Dimension as per year field.

so that all table fields in a chart are changed.

Re: Concat and Sort Year-Month

saimahasan — Tue, 19 Jul 2016 12:41:28 GMT

If you can create a new numeric field for the Year month field:

Say for eg... you have this field saved as YearMonth, then create a new field [Sort YearMonth] as num(YearMonth) and then sort the field YearMonth as per the field [Sort YearMonth] in the expressions under sort tab.