topic Re: breaking a cell in a table in QlikView

breaking a cell in a table

Fri, 28 Aug 2015 06:20:36 GMT

Hello All,

I have a table in this format on SQL:

The Range tab contains the start and end time of each campaign in minutes for each day.

Example:

The first line:

Time	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Start Time	480	1920	3360	2800	6240	7680
End time	1140	2580	4020	5460	6900	7920

Is there a way whereby I can break it like in the table.

Many Thanks for your help.

Kind Regards,

Hasvine

Re: breaking a cell in a table

crusader_ — Fri, 28 Aug 2015 07:24:47 GMT

Hi,

Please attach few rows of your data source in XLS.

It helps to solve your problem faster.

Thanks in advance.

Regards,

Andrei

Re: breaking a cell in a table

Fri, 28 Aug 2015 07:44:45 GMT

Hi Andrei,

I have attached the document in the post.

Many Thanks,

Hasvine

Re: breaking a cell in a table

crusader_ — Fri, 28 Aug 2015 08:27:49 GMT

Hi Hasvine,

PFA my solution.

Regards,

Andrei

Re: breaking a cell in a table

Fri, 28 Aug 2015 08:35:16 GMT

Hi Andrei,

You are a genius. 🙂

Thank you so much. 😄

Kind Regards,

Hasvine

Re: breaking a cell in a table

crusader_ — Fri, 28 Aug 2015 08:37:42 GMT

You are welcome!

Regards,

Andrei

Re: breaking a cell in a table

kkkumar82 — Fri, 28 Aug 2015 10:02:37 GMT

Cheers Andrei, Wonderful logic

Thanks

Kiran Kumar

Re: breaking a cell in a table

Mon, 31 Aug 2015 06:10:08 GMT

Hi Andrei,

Is it possible to only load data between these time only.

Like i have many campaigns and each have there own start time and end time.

I would like to know if its possible to load only these lines which falls in the time frame.

Thanks and Kind Regards,

Hasvine

Re: breaking a cell in a table

crusader_ — Mon, 31 Aug 2015 07:08:41 GMT

Hi Hasvine,

If I understood correctly It possible.

Just add where clause with your restrictions to you last ( on the top) load statement in preceding load or add new preceding load to avoid calsulations and use field names only.

Hope this helps.

Regards,

Andrei

Re: breaking a cell in a table

Mon, 31 Aug 2015 08:05:28 GMT

Hi Andrei,

I have attached a my QVW.

Could you please help me load only the data dusing these working hours.

I am really stuck on this calendar.

Thanks,

Hasvine

Re: breaking a cell in a table

crusader_ — Mon, 31 Aug 2015 08:20:22 GMT

I've downloaded your qvw-file. It's a bit confusing because I'm not good in French.

Also I don't understand termin these working hours, because it could be 8:00AM to 5:00 PM or 9:00 AM to 6:00 PM or even 3:00PM to 12:00 AM, so please clarify this point.

Also mark to which table you need to apply restrictions ( I guess Calendar table, pls confirm, but neither I don't understand to which fields there you need to apply restrictions you have 14 begin/end pairs)

Kind regards,

Andrei

Re: breaking a cell in a table

Mon, 31 Aug 2015 08:46:08 GMT

Actually, there are some campaign which works from 08:00 to 11:00 and then close down from 11:00 to 14:00 and then re open from 14:00 to 19:00. This is why I could not classify them by day and some campaigns are open whole day.

I need the appels reçu and appels servis to count only the calls during the respective working time.

I need the changes to the first table CH01.

Many thanks for your help.

KR,

Hasvine

Re: breaking a cell in a table

crusader_ — Mon, 31 Aug 2015 09:35:51 GMT

Dear Hasvine,

I really want to help, but I cant understand your requirements so far... So, generally I understood that you need to count calls which were made in working time for each company.

But which field(s) indicates working hours for each company? (which field and which table - according to your qvw app)

what field indicates call timestamp (or just time)? (which field and which table - according to your qvw app)

If you do not need extra data in your datamodel you may apply where clause like this "where timecall<WorkEnd1 and timecall> WorkStart1 or timecall<WorkEnd2 and timecall> WorkStart2" for companies which are working the whole day it will be the same fields.

If you need this data in some other aspects of you analysis you can make such restictions in Set analysis as you did in your CH01 chart.

Hope this helps.

Regards,

Andrei