Display same EMPNO values in a single row

[qlikviewwizard]

Hi All,

I am unable to show same EMPNO values into one row.

EMPNO2 has two rows in the screen. But I want to show in a single row.

How to achieve this?

Please help.

Thanks in advance.

[qlikviewwizard]

Hi Digvijay

Yes, I am combining Dimension table and measure value tables as shown in datamodel EMP,SAL,COMM tables.

Please help me. Thanks in advance.

[jagan · Accepted solution]

Hi,

Try this script to fix the DEPTNO issue

DEPT:

LOAD DEPTNO,

     DNAME

FROM

EMPLOYEE.xlsx

(ooxml, embedded labels, table is DEPT);

EMPDEPT:

LOAD DISTINCT

EMPNO,

DEPTNO

FROM

EMPLOYEE.xlsx

(ooxml, embedded labels, table is EMP)

WHERE Len(Trim(DEPTNO)) > 0;

EMP:

LOAD EMPNO,

     ENAME,     

     JOB,

     DATE(HIREDATE) AS HIREDATE,

     DATE(LASTDATE) AS LASTDATE,

     INCHARGE2,

     INCHARGE1

FROM

EMPLOYEE.xlsx

(ooxml, embedded labels, table is EMP);

LEFT JOIN

SAL:

LOAD *,QUARTER &'-'&YEAR AS QUARTERYEAR;

LOAD EMPNO,

     YEAR,

     MONTH,

     QUARTER,

     DATE(STARTDATE) AS STARTDATE,

     SAL

FROM

EMPLOYEE.xlsx

(ooxml, embedded labels, table is SAL);

COMM:

LOAD YEAR,

     'Q' & QUARTER AS QUARTER,

     EMPNO,

     COMM

FROM

EMPLOYEE.xlsx

(ooxml, embedded labels, table is COMM);

Temp:

LOAD INCHARGE1 AS EMPNO,  

     SAL AS INCHARGE1SAL,

     QUARTERYEAR        

RESIDENT EMP

WHERE Len(Trim(INCHARGE1)) > 0

;

Temp:

LOAD INCHARGE2 AS EMPNO,  

     SAL AS INCHARGE2SAL,

     QUARTERYEAR

RESIDENT EMP

WHERE Len(Trim(INCHARGE2)) > 0 or ISNULL(LASTDATE)=-1;

Regards,

jagan.

[jagan]

Also I noticed that there are lot of Synthetic keys in your app, it is not a good practice to have Synthetic keys in the Datamodel.

[qlikviewwizard]

Hi jagan,

I tried with your script. But it is not working in original application.

[jagan]

It should work, copy the whole script and then try to reload.

Regards,

jagan.