topic User Details Missing in QlikView

User Details Missing

Saro_2306 — Mon, 12 Jul 2021 13:02:46 GMT

Hi all,

I am Having User Details (includes User name, DOJ, User Code etc.) in one sheet considering this as Main sheet.

User's Production Details (Includes Months, Week, Date, Production Units, Target ) in Another sheet.

User Name is Common Field for both Sheets. Date field not available in Main Sheet.

In Front End When No Date filter checked, it display all users data and shows 0 for whose production details missing in Sheet 2. But when I Click Month it shows only user's Details whose Production Details available in Sheet 2, it Hides User's Details whose production details not available in Sheet.

I want to show those users details as 0. Any body can help.

Thanks in Advance.

Re: User Details Missing

avinashelite — Mon, 12 Jul 2021 13:57:55 GMT

Please share the sample data so that we could check and provide the solution

Re: User Details Missing

Saro_2306 — Tue, 13 Jul 2021 07:22:05 GMT

Hi @avinashelite please find example data as you requested.

Re: User Details Missing

avinashelite — Tue, 13 Jul 2021 09:31:33 GMT

Actually this is missing data scenario , you need to replicate/duplicate the data for missing months it will lead to additional data . Check the solution below

Test:
LOAD [Emp Code],
[Employee Name],
[User id],
Team
FROM
[C:\Users\Downloads\Example Data.xlsx]
(ooxml, embedded labels, table is [User Details]);

Data:
LOAD [Full Name],
[Full Name] as [Employee Name],
[Production Hours],
Month
FROM
[C:\Users\Downloads\Example Data.xlsx]
(ooxml, embedded labels, table is [Production Details]);

Test1:
LOAD
Month
Resident
Data;

Join(Test1)
LOAD
[Employee Name] as EMP
Resident
Test
Where Not Exists([Full Name],[Employee Name]);

join(Data)
LOAD
Month,
EMP as [Employee Name]
Resident
Test1;

Drop Table Test1;

Re: User Details Missing

Saro_2306 — Tue, 13 Jul 2021 13:35:06 GMT

Thanks @avinashelite . Its Working. I made few changes for my script.