topic Re: Help in QlikView

Help

panipat1990 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have a requirrment. I have a Fact table where Date of joining(DOJ) Field And Retirement date(Field)..And another date field name is (leaving date) and Confirmation Date Field.is coming from master..I Want to make one common date to connect with my master calender. For This I am sharing excel.kindly help me for solving this requirement.

Excel Master is my master Table

excel_Transaction Is my fact table.and Emp Id is common key between two table.

Re: Help

panipat1990 — Thu, 09 Jun 2016 19:15:24 GMT

is this possible in qlikview.

Re: Help

Fri, 10 Jun 2016 02:46:16 GMT

Hi,

Is this what you're looking for

Re: Help

prma7799 — Fri, 10 Jun 2016 05:59:13 GMT

What is your exact retirement ?

Re: Help

jonathandienst — Fri, 10 Jun 2016 06:09:04 GMT

This is how to link multiple dates to a single calendar:

Canonical Date

Re: Help

Digvijay_Singh — Fri, 10 Jun 2016 06:31:15 GMT

Your confirm date seems out of order, can you check if it is correct in attached sample.

Re: Help

arasantorule — Fri, 10 Jun 2016 07:06:07 GMT

Hi,

I am thinking the below way by spliting tables into 4,

1. Emplyee, Leaving Date

2. Employee, Joining Date

3. Employee, Retirement Date

4. Employee, Confirmation Date

Create a link table to concatenate all the tables using Employee ID and Date with the common date flag filed.

Create a Calendar using the date flag available in the link table.

Hope this helps.

Re: Help

Digvijay_Singh — Fri, 10 Jun 2016 07:13:41 GMT

You may use below attached sample -

Re: Help

Digvijay_Singh — Fri, 10 Jun 2016 07:21:29 GMT

Small modification in below to correct date format

Re: Help

panipat1990 — Tue, 14 Jun 2016 11:12:49 GMT

Can you share me one qvw

Re: Help

panipat1990 — Thu, 16 Jun 2016 05:45:19 GMT

Hi Sir,

Can you share me qvw regarding making calender

Re: Help

Digvijay_Singh — Thu, 16 Jun 2016 06:10:09 GMT

Hi,

I derived the earlier attached one from this one. It has calendar for each date. Hope this will help.

I think I missed your last message about attaching qvw, hope you got the last qvw I attached on 10th.

Please close the thread and mark correct/helpful answers or post additional questions for further help.

Regards,

Digvijay

Re: Help

Digvijay_Singh — Thu, 16 Jun 2016 06:11:48 GMT

Not sure why prev reply is not showing attachment, re-attaching here.

Re: Help

panipat1990 — Thu, 16 Jun 2016 09:32:48 GMT

Sir Previous Attachment is not showing and i didnot get it.Kindly share me

Re: Help

panipat1990 — Thu, 16 Jun 2016 18:39:24 GMT

Hi Sir,

Can you share me again that qvw..because i didnot get any qvw...

Re: Help

Digvijay_Singh — Thu, 16 Jun 2016 18:47:19 GMT

Do you mean you are not able to attachments, I can see files attached to my posts, sending again. Not sure if I understood if you don't see the files or the required things in the files. Please elaborate once more in case you I am not on same page.