Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Partner
Partner

Hi Paul

USe Concatenate like below:

MI_Completes:

LOAD *

FROM (qvd);

Concatenate

View_MI_WIP:

LOAD *

FROM (qvd);

Have fun with QV,

François

Highlighted

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

Highlighted
Creator III
Creator III

CONCATENATE would help.

Highlighted
Partner
Partner

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

Highlighted
Creator
Creator

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..

Highlighted
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

Highlighted
Creator
Creator

Actually i am getting date 07/01/2014.

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

Capture.PNG

Highlighted
Creator III
Creator III

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

Highlighted

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...