Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Need Help

Hi Community,

I have 2 QVD's i have more than 10 same fields.

How to handle that???

Please anyone help me....!!

PFA.

11 Replies
francoiscave
Partner - Creator III
Partner - Creator III

Hi Paul

USe Concatenate like below:

MI_Completes:

LOAD *

FROM (qvd);

Concatenate

View_MI_WIP:

LOAD *

FROM (qvd);

Have fun with QV,

François

alexandros17
Partner - Champion III
Partner - Champion III

If there is not a logical relation (E.g. Master-Detail) thden you can concatenate the 2 tables:

load ... from ...

concatenate

load ... from

Let me know

reshmakala
Creator III
Creator III

CONCATENATE would help.

francoiscave
Partner - Creator III
Partner - Creator III

Hi Paul,

Have you need some more help ?

If not, can you mark an answer as Correct or helpful to close this thread.

Thanks,

François

paulwalker
Creator III
Creator III
Author

Hi Francois,

I have done concatenate, and i have created Calendar also..

when i reload script it showing error, script line error..

anything wrong in script..

reshmakala
Creator III
Creator III

Load Date($(vMinDate)+RecNo()-1) as TempDate

AutoGenerate $(vMaxDate) -$(vMinDate);

Here, there is no value coming up for $(vMinDate) causing nullvalue + RecNo() and so is a script line error

paulwalker
Creator III
Creator III
Author

Actually i am getting date 07/01/2014.

but this is not Minimum date, actually i have 2013 data also..

Capture.PNG

reshmakala
Creator III
Creator III

What did you wnated to achieve by vMinDate+RecNo()-1??

Peter_Cammaert
Partner - Champion III
Partner - Champion III

The last error is probably caused by an empty vMaxDate variable. Only the -$(vMinDate) part remains, leading to a negative AUTOGENERATE value and that is not accepted as a valid count.

Check your variables. You better get Min/Max date values by using something like:

MinMaxTable:

LOAD Min(DateCompleted) AS MinDate, Max(DateCompleted) AS MaxDate

RESIDENT MI_Completes1;

and then peeking into the single record of this table to get correct values. Your current code depends on the correct ordering of one of your source tables (first/last row) and that may produce unpredictable results...