topic Re: need urgent reply in QlikView

need urgent reply

Thu, 27 Jun 2013 10:10:13 GMT

Hi..can any one help me this issue ...i am going to create 3 dashboard ..1st dashboard with 3 months of data and 2nd dashboard with 6 months of data and 3rd dashboard with 1 year data ...for that i am thinking to create 3 qvd's for 3 , 6 and 1 year seperately and then will use those qvd's in respective qvw of dashboard ., but my issue is that instead of creating 3 qvd's is there any other ways means can restruct in the qvw itself by creating one qvd with whole data? pls help me this ..

Regards,

Sh.

Re: need urgent reply

Anonymous — Thu, 27 Jun 2013 10:25:17 GMT

To make maintenance easier I would have one qvw with all the data, and restrict the amount of data being shown within each chart's expressions.

You can create StartDate and EndDate variables and then use set analysis like this:

sum({<TransDate={'>=$(StartDate) <=$(EndDate)'}>} Value)

Jonathan

Re: need urgent reply

tresB — Thu, 27 Jun 2013 10:25:29 GMT

While load the data into qvw file (dashborad) you can put a WHERE clause to restrict the data (date wise) for different dashborads.

Something Like:

LOAD

Date,

....

From ... Where Date < 'YourDate' ;

Note: Different Dates for different dashborads from the same source.

Re: need urgent reply

Thu, 27 Jun 2013 10:26:40 GMT

Hope at least u have one Transection Table(Put in one qvd)..

Create a Calender Master..

Then ur Dashboard requirement wise extract data from that qvd..3Month,6Month,1Year wise data just calculate in expression lebel.

Regards-Bika

Re: need urgent reply

Thu, 27 Jun 2013 11:22:11 GMT

Yeah thanks for that reply , but i tried in qvw by loading qvd into that and i gave filter condition after that trying to reload it but nt able to reload getting error ...pls let me know how to use where condition in the qvw(dashboard) level...

regards,

Sh.

FIY..

LOAD

id,

case_number,

createddate,

.......,

......,

.....

from

path.qvd;

Re: need urgent reply

narender123 — Thu, 27 Jun 2013 11:30:41 GMT

You can use where clause in your script

Like'

Load

monthno,

year,

day

from table1 where monthno>=1 and monthno<=3;

or you can write it as

from table1 where month>jan and monthno<=mar;

you can also user date

from table1 where date>=01/01/2013 and date<=01/01/2013;

Thanks

Re: need urgent reply

tresB — Thu, 27 Jun 2013 11:33:32 GMT

Load

Field1,

Field2,

Date

From <your qvd path> where Date < '1/1/2013' and Date > '31/6/2012 ;

This will pull six month data. And you can make this conditional load (using where clause) more dynamic based on your rquirement.

Re: need urgent reply

Thu, 27 Jun 2013 12:18:44 GMT

again thanks , but i tried like that but getting syntax error ...

FYI..

LOAD

Createddare,

ETL_INSERT_USER,
ETL_UPDATE_DATE,
ETL_UPDATE_USER
FROM

where CreatedDate < '1/1/2013' and CreatedDate > '31/6/2012 ;
(qvd);

Pls check it and let me know if i did any mistake ..

Regards,

Sh.

Re: need urgent reply

tresB — Thu, 27 Jun 2013 12:25:58 GMT

First look says, CreatedDate and Createddare.......?

Re: need urgent reply

narender123 — Thu, 27 Jun 2013 12:26:34 GMT

Hi,

LOAD

Createddare,

ETL_INSERT_USER,
ETL_UPDATE_DATE,
ETL_UPDATE_USER
FROM

You have to place where clause just before ;

Thanks.

Re: need urgent reply

narender123 — Thu, 27 Jun 2013 12:36:12 GMT

You just need to put where cluase before ; and u must have CreatedDate in your table where you applied where cluase.

Thanks

Narender