Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion
Champion

HOW TO LOAD DISTINCT VALUES IN QV LOAD

DEAR ALL

I HAVE FOLLOWING RECORDS

DOC NO       PROD CD   QTY   BAISIC   TAX

------------------------------------------------------------

123               XYZ          10         100       120

123              ABC          20         200      120

123               PQR          30       300        120

120 TAX IS COMMON FOR DOC NO 123 NOW WHILE LOADING IN QV  I WANT ONLY 120 SHOULD TAKE

DISTINCT PLEASE GUIDE ME HOW TO ACHIVE THIS IN QV RELOAD.

REGARDS AND THANKS

VIKAS

1 Solution

Accepted Solutions
Highlighted

Split the table as like below

TempTable:

Load

[DOC NO],[PROD CD],QTY,BAISIC, TAX

From DataSource;

Table1: //Except TAX

Load

[DOC NO],[PROD CD],QTY,BAISIC

Resident TempTable;

Table2:

Load Distinct [DOC NO], TAX

Resident

TempTable;

Drop Table TempTable;

View solution in original post

1 Reply
Highlighted

Split the table as like below

TempTable:

Load

[DOC NO],[PROD CD],QTY,BAISIC, TAX

From DataSource;

Table1: //Except TAX

Load

[DOC NO],[PROD CD],QTY,BAISIC

Resident TempTable;

Table2:

Load Distinct [DOC NO], TAX

Resident

TempTable;

Drop Table TempTable;

View solution in original post