topic Re: Need Help in QlikView

Need Help

paulwalker — Wed, 14 Jan 2015 15:24:11 GMT

Hi Community,

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

How to handle that???

Please anyone help me....!!

PFA.

Re: Need Help

francoiscave — Wed, 14 Jan 2015 15:26:08 GMT

Hi Paul

USe Concatenate like below:

MI_Completes:

LOAD *

FROM (qvd);

Concatenate

View_MI_WIP:

LOAD *

FROM (qvd);

Have fun with QV,

François

Re: Need Help

alexandros17 — Wed, 14 Jan 2015 15:27:45 GMT

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

Re: Need Help

reshmakala — Wed, 14 Jan 2015 15:28:34 GMT

CONCATENATE would help.

Re: Need Help

francoiscave — Thu, 15 Jan 2015 11:22:31 GMT

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

Re: Need Help

paulwalker — Thu, 15 Jan 2015 16:29:02 GMT

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

Re: Need Help

reshmakala — Thu, 15 Jan 2015 16:32:18 GMT

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

Re: Need Help

paulwalker — Thu, 15 Jan 2015 16:40:51 GMT

Actually i am getting date 07/01/2014.

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

Re: Need Help

reshmakala — Thu, 15 Jan 2015 16:44:58 GMT

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

Re: Need Help

Peter_Cammaert — Thu, 15 Jan 2015 16:57:00 GMT

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

Re: Need Help

paulwalker — Thu, 15 Jan 2015 16:57:50 GMT

Reshma,

forget that,

i have done concatenate write..

i want to create calendar based on Completed_Date..

Re: Need Help

paulwalker — Thu, 15 Jan 2015 17:12:38 GMT

Thanks for clarification....