Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
limfungkeat
Contributor III
Contributor III
‎2019-04-11 08:14 PM

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
Labels (2)
989 Views
0 Likes
1 Solution

Accepted Solutions
chrismarlow
Specialist II
Specialist II
‎2019-04-16 03:30 PM

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.

View solution in original post

963 Views
0 Likes
2 Replies
chrismarlow
Specialist II
Specialist II
‎2019-04-16 03:30 PM

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.

964 Views
0 Likes
limfungkeat
Contributor III
Contributor III
‎2019-04-16 08:10 PM
Author

In response to chrismarlow

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

 

957 Views