topic Re: How can sort special format date in search object's results? in QlikView

How can sort special format date in search object's results?

Mon, 26 Jan 2026 18:19:17 GMT

I have a search object that linked to a field contains Persian dates , I wanna sort in in decreasing way

Re: How can sort special format date in search object's results?

hic — Sat, 03 May 2014 21:59:12 GMT

Can you post a data sample?

HIC

Re: How can sort special format date in search object's results?

Sun, 04 May 2014 04:23:55 GMT

Sure , They are in this format : yyyy/mm/dd like 1393/01/14 , 1393/01/16 , 1393/02/10 ,... I want to see the search box's results from the last date to the first

Re: How can sort special format date in search object's results?

Sun, 04 May 2014 05:38:02 GMT

have you tried in the properties of the search object in the order sheet?

regards, Marcelo

Re: How can sort special format date in search object's results?

Sun, 04 May 2014 06:41:09 GMT

Yes I think ! You mean the sort sheet in search object properties as in the below picture?

You know that Qlikview doesn't support Persian date so we needed to write a module to convert Gregorian date to Persian date and our data source is a Sharepoint list so I guessed that QV behaves with this field's value like a string and a normal sort works but it doesn't

Thanks for your help

Re: Re: How can sort special format date in search object's results?

tresB — Sun, 04 May 2014 13:41:08 GMT

It seems that, sort order of a field in search object is actually taken from the recent most set sort order of the same field. Hence, try to set sort order of your Date field (list box) accordingly (in your case, Z->A works). The behavior would be reflected in the search object as well.

Re: Re: How can sort special format date in search object's results?

rbecher — Sun, 04 May 2014 18:14:10 GMT

Btw. I created a calendar/mapping table with Persian Date once in Oracle. This was a no-brainer and probably better to link or load the data to your QlikView data model than creating a conversion module..

- Ralf

Re: Re: How can sort special format date in search object's results?

Mon, 05 May 2014 05:30:19 GMT

Thanks

Re: Re: How can sort special format date in search object's results?

Sat, 18 Oct 2014 09:12:06 GMT

Hi Ralf

I'm suppose to use this persian calender that you created , but I dont know how would you please give me more details about using it in my report?

Re: How can sort special format date in search object's results?

rbecher — Wed, 29 Oct 2014 10:44:09 GMT

Just load the attached TSV table and you will have a Persian date for each day..

- Ralf

Re: Re: How can sort special format date in search object's results?

Fri, 28 Nov 2014 14:34:47 GMT

dear Ralf

I attached a sample and want to persian date in list box

thanks

Re: Re: Re: How can sort special format date in search object's results?

rbecher — Fri, 28 Nov 2014 14:59:30 GMT

Please find attached. You can select Today indirectly via GREGORIAN_DATE.

- Ralf

Re: How can sort special format date in search object's results?

mr_ramshini — Tue, 17 May 2016 03:08:13 GMT

Hi Ralf

Can i do it without list box?

i want convert system date to persian date and show it on text box

please help me

Thanks

Re: How can sort special format date in search object's results?

mr_ramshini — Tue, 17 May 2016 05:42:47 GMT

i want change date to persian date

please help me

Thanks

Re: How can sort special format date in search object's results?

rbecher — Tue, 17 May 2016 08:59:15 GMT

Hi Hossein,

if you use my app above you can code in a text box:

=minstring({1<QV_DATE_NUM={"$(=num(today(1)))"}>} PERSIAN_DATE)

- Ralf

Re: How can sort special format date in search object's results?

mr_ramshini — Wed, 18 May 2016 05:27:43 GMT

Thanks for your help

but i have a qv file and i want show the last execution time to persian date on text box

but i can't solve it

please help me

Re: How can sort special format date in search object's results?

rbecher — Wed, 18 May 2016 05:33:39 GMT

Do you mean the date of last script load? This would be:

=minstring({1<QV_DATE_NUM={"$(=num(today(0)))"}>} PERSIAN_DATE)

Re: How can sort special format date in search object's results?

rbecher — Wed, 18 May 2016 08:34:38 GMT

ReloadTime() as Persian Date would be:

=minstring({1<QV_DATE_NUM={"$(=num(today(0)))"}>} PERSIAN_DATE)
& ' ' & Time(TimeStamp#(ReloadTime()))

- Ralf

Re: How can sort special format date in search object's results?

mr_ramshini — Wed, 29 Jun 2016 10:00:30 GMT

Hi Ralf

your answer was very useful

but i can do it without persian_date_rb file?

In fact i want change my system date to persian date with out i use of persian_date_rb file?

Re: How can sort special format date in search object's results?

rbecher — Wed, 29 Jun 2016 10:41:48 GMT

Hi Hossein,

no, because QlikView doesn't know a Persian date..

- Ralf