topic Re: How to Join and solve the issue in QlikView

How to Join and solve the issue

Thu, 24 Apr 2014 07:05:17 GMT

we have 3 QVD's. we need to club all these QVD 's into single QVD .. we have common key in all 3 QVD.

i used concatenate ..

after loading into single QVD , We call that qvd in a QVW and pulled the data in excel...

when we compare the FInal QVD data with each individual qvd data, the data in excel is

showing Blanks(ex: -) that means the joing is not correct.

How to solve this..

sample qvw PFA..

Re: How to Join and solve the issue

its_anandrjs — Thu, 24 Apr 2014 07:11:59 GMT

Check the common key it is unique or the multiple in nature like its frequency. An let me know.

Re: How to Join and solve the issue

Thu, 24 Apr 2014 07:15:22 GMT

Hi Anand ,

Its unique key..

Re: How to Join and solve the issue

its_anandrjs — Thu, 24 Apr 2014 07:16:21 GMT

You use Noconcatenate so how it will join and concatenate please check your script.

Re: How to Join and solve the issue

Thu, 24 Apr 2014 07:19:26 GMT

Sorry i sent u the wrong QVW...i tried with Concatenate only ...but its the same result...

Re: How to Join and solve the issue

Thu, 24 Apr 2014 07:20:52 GMT

Hi,

If you need these 3 tables in the same qvd with the same fields you should use Concatenate instead of No Concatenate.

Regards,

Re: How to Join and solve the issue

Thu, 24 Apr 2014 07:25:12 GMT

ya i tried with concatenate only...but the data in excel is showing blanks even though the data in Original qvd has Values

say ex: forecastTeamComitAMount has count of 2613 records

but in FInal QVD in excel the data is showing blanks..

Re: How to Join and solve the issue

its_anandrjs — Thu, 24 Apr 2014 07:25:58 GMT

Your table name is different to each other and when you concatenate the tables you get some - blank in the rows if the field name should same then concatenate other wise join then on the basis of the key field. And add the Table flag to identify the records like

Tab1:

Load * 'Tab1' as TableFlag from Location;

Concatenate

Tab2:

Load * 'Tab2' as TableFlag from Location;

Re: How to Join and solve the issue

its_anandrjs — Thu, 24 Apr 2014 07:28:55 GMT

Try to concatenate the tables one by one and cross check the data with excel and raw source.

Re: How to Join and solve the issue

jagan — Thu, 24 Apr 2014 07:34:26 GMT

Hi Abhinav,

You are giving NoConcatenate, that is why the second and third qvd is not loading. Try like this

Forecast:

LOAD

FROM QVD1;

Concatenate(Forecast)

LOAD

FROM QVD2;

Concatenate(Forecast)

LOAD

FROM QVD3;

Hope this helps you.

Regards,

Jagan.

Re: How to Join and solve the issue

Tue, 29 Apr 2014 06:13:14 GMT

Hi All,

I ahve a QVW which will generate QVDon weekly basis.

now i need to change the master calendar to generate the QVd in Monthly

basis. This is the master calendar we are using

LET tableloadStartTime=0;

SET vTotalRecordCount = 0;

Let NoOfDaysShift =0;

LET tableloadStartTime=Now(1);

if(WeekDay(today())<> 'Sat') and (WeekDay(today())<> 'Sun') Then

let NoOfDaysShift= num(WeekDay(today())*-1)-1;

ENDIF

IF (WeekDay(today())= 'Sun') Then

let NoOfDaysShift= -1;

ENDIF

let vExecDate = date(today()+$(NoOfDaysShift),'MM/DD/YYYY') ;

trace The date of execution is : $(vExecDate);

Let vToday = Today(1); // Custom Run

Let vToday_Num = num(floor(today(1)+$(NoOfDaysShift)));

According to this code QVD will generate on Every Sunday in a week.

Now i need to Change the code to load QVD on sunday in a Monthly once

EX: suppose if i run QVW on 29-4-2014 it generate the QVD based on

27-4-2014.

next if i change the let NoOfDaysShift= num(WeekDay(today())*-1)-1; code to

let NoOfDaysShift= num(WeekDay(today())*-1)+5; it will generate next sunday

date which is 03-05-2014

same way i need to change the code . I need to generate the QVD on Monthly

basis..

means if i run the QVW today it have to run Only first sunday of every

month (i.e 6-4-2014). if i run the QVW tomarrow , also it has to run on

6-4-2014.

In the next month it have to run on 4-5-2014.

How to change the Master Calendar