topic AW:Single date field split into dateto and datefrom in QlikView

Single date field split into dateto and datefrom

neetu_singh — Mon, 28 Jun 2010 06:26:23 GMT

Hi Everyone,

I need a help , can anyone suggest me the solutions. I have a field as "Date Column" and want to split into two fields as "dateto" and "datefrom" in multibox or in calender object. i need this without using variables.

Example as shown below:

I have a field named as "DATE". want into two multibox as Date To and Date From

MultiBox1 Multibox2

DateFrom DateTo

yearfrom monthfrom dayfrom yearto monthto dayto.

Please revert back ASAP.

Thanks in advance

AW:Single date field split into dateto and datefrom

brenner_martina — Mon, 28 Jun 2010 08:20:38 GMT

Hi,

please put the function in the script, because expressions in a list- or multibox can not be sorted.

What is the content in your DATE-field? is it a string like: 2010/6/15-2010/6/21? Then you can split the string with left, mid and right:

left( Date, 4 ) where Date = 1997-07-14 returns 1997

right( Date,2 ) where Date = 1997-07-14 returns 14

mid( Date,3,2 ) where Date = 970714 returns 07

AW:Single date field split into dateto and datefrom

Mon, 28 Jun 2010 08:41:56 GMT

We also want solution of this problem .

Regards

Ashish Srivastava

AW:Single date field split into dateto and datefrom

neetu_singh — Mon, 28 Jun 2010 08:58:18 GMT

Hi Martina,

Thnks for ur reply. But i dn't want to split into year month and date.

i want to use a single "Date" in two ways one which gives "ToDate" and another gives "FromDate".

user can select randomly from both. if he want to see the data from 2010/1/01 to 2010/2/25. then he can select 2010/1/01 from "FromDate" field and 2010/2/25 from "ToDate".

Hope now u can understand my requirement.

If u have any solution related to this. Please reply ASAP.

I m very thankful to u

Neetu Singh

AW:Single date field split into dateto and datefrom

johnw — Tue, 29 Jun 2010 01:45:36 GMT

Well, attached is a horrible solution, at least if you have very many dates. I've joined the date field to itself twice to produce every combination of date range and the dates in that range. Works great for the sample, but if you have 1000 dates, you'll have a billion rows before it narrows things down.

It seems like you SHOULD be able to just have a FromDate and a ToDate table separate from the main data, then OnSelect, trigger an action to select the Dates in the range. So far I've been unsuccessful at making it work (I'm new to actions).

You might also consider a multi-value slider object on the date field.

Single date field split into dateto and datefrom

Tue, 29 Jun 2010 03:48:18 GMT

I want to know the answers too. Pls help.

AW:Single date field split into dateto and datefrom

neetu_singh — Tue, 29 Jun 2010 06:10:20 GMT

Hi John,

Thanks a lot for your reply. I need something like that.

Regards

Neetu Singh