Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Organise Data Within Load For Calendar

Hi,

I currently have a dataset that I want to convert into a visual calendar within QlikView.  I beleive the best way to do this would be to set it up within a pivot table.  The problem that I have is the data itself and how to go about combining certain fields based upon the date and time.

Example Raw Table:

KeyDateDayActionTime
111/03/2013MonVisit11am
212/03/2013TueVisit10am
313/03/2013WedVisit2pm
414/03/2013ThurVisit3pm
512/03/2013TueCall2pm
612/03/2013TueCall4pm
714/03/2013ThurCall10am

What I want to get to:

DateDayDetail
11/03/2013MonVisit @ 11am
12/03/2013TueVisit @10am  Call @ 2pm  Call @ 4pm
13/03/2013WedVisit @ 2pm
14/03/2013ThurCall @ 10am   Visit @ 3pm

I have no idea how to do a field merge based upon a lookup.

Can anyone help point me in the right direction?

Many thanks

Tags (2)
1 Solution

Accepted Solutions

Re: Organise Data Within Load For Calendar

Something like: concat( Action & ' @ ' & Time, '   ', Key )

See attached qvw

If you want to calculate this in the script use something like:

load Date, concat( Action & ' @ ' & Time, '   ', Key ) as Actions

from ...somewhere...

group by Date;


talk is cheap, supply exceeds demand
3 Replies

Re: Organise Data Within Load For Calendar

Something like: concat( Action & ' @ ' & Time, '   ', Key )

See attached qvw

If you want to calculate this in the script use something like:

load Date, concat( Action & ' @ ' & Time, '   ', Key ) as Actions

from ...somewhere...

group by Date;


talk is cheap, supply exceeds demand
Not applicable

Re: Organise Data Within Load For Calendar

Thats great.  Thankyou for your help

Not applicable

Re: Organise Data Within Load For Calendar

Is it possible to use a character return on order to split up the date within the field?

I have tried

 

chr(13)

this does not appear to work.

Community Browser