Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
limfungkeat
New Contributor III

Displaying Duplicates Records in Straight Table

Below the datasource from oracle table . Noticed that there are this row 5, and 6 with red color , are duplicates. How am i suppose to display all the rows in straight table . The script and expression is as below : 

 

NPDScript:

select FORM_ID,EMP_NO,EMP_NM, PROD_NM,SITE,ACTIVITIES,ACT_DATE,MANHRS,TIMESHEET_DATE,APPROVEDDATE,TOTAL_COST,PHASE FROM timesheet_npd order by approveddate ;
NoConcatenate
Load FORM_ID,EMP_NO,EMP_NM as emplyeenames,PROD_NM,SITE,ACTIVITIES, ACT_DATE,MANHRS as manhrs_npd,TIMESHEET_DATE, floor(APPROVEDDATE) as appDates,TOTAL_COST,PHASE
Resident NPDScript;
Drop table NPDScript ;

Expression : 

if(appDates >=vStartDate and appDates <=vEndDate,appDates,0)

 

EMP_NOEMP_NMDATE_FROMDATE_TOCODEPROD_NMACT_DATEACTIVITIESMANHRSAPPROVEDDATEAPPROVEDSITEBUDGETED_HRSTOTAL_COSTTIMESHEET_DATEPHASE  
00003344ABC25-Mar-1929-Mar-19OSDAmlodipine Tablets 5mg27-Mar-19Review report- Assistant Managers & above2###########YPMB 230#############DEVELOPMENT PHASE
00003344ABC25-Mar-1929-Mar-19OSDBisoprolol Tablets 2.5 mg27-Mar-19Analytical Method Validation (AMV) protocol3###########YPMB 345#############DEVELOPMENT PHASE
00003344ABC25-Mar-1929-Mar-19OSDBisoprolol Tablets 5 mg29-Mar-19Analytical Method Validation (AMV) protocol3###########YPMB 345#############DEVELOPMENT PHASE
00003344ABC25-Mar-1929-Mar-19OSDBisoprolol Tablets 10 mg29-Mar-19Analytical Method Validation (AMV) protocol3###########YPMB 345#############DEVELOPMENT PHASE
00003344ABC25-Mar-1929-Mar-19OSDIrbesartan Tab 300 mg25-Mar-19Analytical Method Validation (AMV) protocol1###########YPMB 115#############DEVELOPMENT PHASE
00003344ABC25-Mar-1929-Mar-19OSDIrbesartan Tab 300 mg25-Mar-19Analytical Method Validation (AMV) protocol1###########YPMB 115#############DEVELOPMENT PHASE
00003344ABC25-Mar-1929-Mar-19OSDAmlodipine Tablets 10mg25-Mar-19Analytical Method Validation (AMV) protocol2###########YPMB 230#############DEVELOPMENT PHASE
00003344ABC25-Mar-1929-Mar-19OSDAmlodipine Tablets 5mg25-Mar-19Analytical Method Validation (AMV) protocol2###########YPMB 230#############DEVELOPMENT PHASE
1 Solution

Accepted Solutions
chrismarlow
Valued Contributor

Re: Displaying Duplicates Records in Straight Table

Hi,

You can try adding a row number in script to make rows unique & then hide column after using as a dimension/expression/both;

data:
Load
	RowNo() AS ROW,
	*;
LOAD * INLINE [
    Dim, Mea
    1, 1
    1, 1
    2, 2
];

20190416_1.png

 

Cheers,

Chris.

2 Replies
chrismarlow
Valued Contributor

Re: Displaying Duplicates Records in Straight Table

Hi,

You can try adding a row number in script to make rows unique & then hide column after using as a dimension/expression/both;

data:
Load
	RowNo() AS ROW,
	*;
LOAD * INLINE [
    Dim, Mea
    1, 1
    1, 1
    2, 2
];

20190416_1.png

 

Cheers,

Chris.

limfungkeat
New Contributor III

Re: Displaying Duplicates Records in Straight Table

Thanks a lot ! Chris . Never think of hiding the column too . It is a very useful tips a s well .

Have a nice day

Lim