Qualifier

[dhavalvyas]

What is Qualifier ? i am new to qlikview,can any one tell me with the help of example ?

[sarvesh]

Qualify does not work that way when you concatenate files. Although you are not using the CONCATENATE keyword, it is happening because you are loading multiple files (DSI*.csv). QUALIFY, as you already know, prefixes each field with the name of the table, and each iteration of a concatenation with QUALIFY will end the table label with "-1", "-2" and so on.

So you will have to do two steps. First a noncatenated load of all fields from the DSI*.csv files, store them into QVD files, then using QUALIFY load all fields from this other load. However, in your case, I'd concatenate the Invoices and Credits table as I suggested in a previous post.

1. Invoices: 
2. LOAD [Invoice No], 
3.      [Acc No] as AccNo, 
4.      [Cust Name], 
5.      Rep, 
6.      [Profit/Loss], 
7.      [New % Margin/Loss], 
8.      [Order Value] 
9.      //Date(Date) as date commented out to stop the link creating a synthetic key 
10. FROM DSI*.csv 
11.  
12. STORE Invoices INTO Invoices.qvd (qvd); 
13.  
14. DROP TABLE Invoices; 
15.  
16. QUALIFY *; 
17. UNQUALIFY AccNo; 
18. Invoices: 
19. LOAD * 
20. FROM Invoices.qvd (qvd); 

[ecolomer]

See this:

Do you Qualify?- How to use QUALIFY statement

[Frank_Hartmann]

this might be interesting too:

What does the TOTAL qualifier do?

hope this helps!