topic Issue with date mapping in QlikView

Issue with date mapping

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

Hi Community,

I have Employee table(Manual report, someone entering the data), by default Employee table associating with EmpID to main table,

My requirement

few data not mapping because few data not associating Date level, but I have to show all records for all months.

My Idea, can we create one derived column for all the months in the script level, then I can map EmpID & Date key??

Example: Jan 2018 full data set, Feb 2018 full data set and so on....... till Dec 2018

Please could you give suggestion Experts ??

Thanks In Advance.....

kfoudhaily — Mon, 18 Jun 2018 14:45:43 GMT

what is the rule to determine(calculate) this column: Date (Derived Column)?

Nagaraju_KCS — Mon, 18 Jun 2018 14:54:10 GMT

I have Employee table, they are entering manually, so I don't have date field. (No rules)

I'm fetching only EmpName in this table, calculation fields coming from different tables.

Just I have to loop all the Year and Month level data.... like above mentioned

Nagaraju_KCS — Mon, 18 Jun 2018 16:47:47 GMT

Experts!! is there any possibility like full data set loop..

Please suggest

marcus_sommer — Tue, 19 Jun 2018 12:44:10 GMT

You could do something like this:

for i = 1 to 12

t: load EmpID, Cost, EmpName, $(i) as Month from Excel;

But creating a key of EmpID and Month is only useful if there are appropriate data within your other tables ..

- Marcus