Qualifier

dhavalvyas — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qualifier

sarvesh — Sat, 18 Mar 2017 06:33:48 GMT

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.

Invoices:
LOAD [Invoice No],
[Acc No] as AccNo,
[Cust Name],
Rep,
[Profit/Loss],
[New % Margin/Loss],
[Order Value]
//Date(Date) as date commented out to stop the link creating a synthetic key
FROM DSI*.csv
STORE Invoices INTO Invoices.qvd (qvd);
DROP TABLE Invoices;
QUALIFY *;
UNQUALIFY AccNo;
Invoices:
LOAD *
FROM Invoices.qvd (qvd);

Re: Qualifier

ecolomer — Sat, 18 Mar 2017 06:40:47 GMT

See this:

Do you Qualify?- How to use QUALIFY statement

Re: Qualifier

Frank_Hartmann — Sun, 19 Mar 2017 10:21:05 GMT

this might be interesting too:

What does the TOTAL qualifier do?

hope this helps!

topic Qualifier in QlikView

Qualifier

Re: Qualifier

Re: Qualifier

Re: Qualifier