topic pls suggest in QlikView

pls suggest

Tue, 05 Apr 2011 14:27:15 GMT

Hi,

Pls see the enclosed app.I have loaded only 10 days of days here .so its fast but if I load the entire data it is very very slow.i think its because of the ifs am using in the expressions.Is there a way to avoid these ifs and put in the load script.Pls suggest.

Pl See:Blackhawk GC Redemption Counts by Month - Fully Redeemed

Thanks,Swetha

pls suggest

Tue, 05 Apr 2011 14:58:53 GMT

Hi,

I am not able to down load your doc.Can you attach the doc seperately

Thanks & Regards

Jai

pls suggest

Tue, 05 Apr 2011 15:04:48 GMT

Pls find teh doc attached.

pls suggest

Tue, 05 Apr 2011 15:18:12 GMT

Hi,

As per our company policy I was not able to download any '.zip' doc. if possible attach one by one.Sorry for the in convenience

Thanks & Regards

Jai

pls suggest

Tue, 05 Apr 2011 15:24:00 GMT

pls see the app.

pls suggest

Tue, 05 Apr 2011 15:44:28 GMT

Hi,

In your pivot table "grouping" function is missing.With out grouping function it will be very hard to load the data.So I have updated one of your pivot table of "Blackhawk GC Redemption Counts by Month - Fully Redeemed_updated_jai " and attached here.Have a look and if you have any query let me know the same.

Thanks & Regards

Jai

pls suggest

Tue, 05 Apr 2011 15:46:44 GMT

Thanks for the reply Jai.But when I open your report it shows allocated memory exceeded,Thats also one of teh problem am facing.

pls suggest

Tue, 05 Apr 2011 15:54:29 GMT

Hi,

If possible select some values in list box.That time you will get some values.Better create qvd's then pull the data.And also have a look in data model.It may help you.For further query reply back.

Thanks & Regards

Jai

pls suggest

Tue, 05 Apr 2011 15:54:38 GMT

And also the data does not match with the original report I have sent.

Thanks

pls suggest

Tue, 05 Apr 2011 16:01:50 GMT

I have only selected one day .And I guess you have added the expression:

=only(if(CALENDAR_DATE>=VSTARTDATE and CALENDAR_DATE<=VENDDATE and

GC_BALANCE1='0',GC_CARD_NUMBER))

to the dimensions tab.Whenever I did that it just says it exceeded memory even If I select only one day.

pls suggest

Tue, 05 Apr 2011 17:59:33 GMT

Hi Jai,

I have seen ur updated app clearly and its good,but when I load the entire data using qvds it says out of memory ,any ideas wud be appreciated.

Here is the script:

SET

ThousandSep=','

;

SET

DecimalSep='.'

;

SET

MoneyThousandSep=','

;

SET

MoneyDecimalSep='.'

;

SET

MoneyFormat='$#,##0.00;($#,##0.00)'

;

SET

TimeFormat='h:mm:ss TT'

;

SET

DateFormat='M/D/YYYY'

;

SET

TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

;

SET

MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

;

SET

DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

;

CONNECT

TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DMC_GIFTCARD;Data Source=DATAWHSE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MIS-DW2;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is

IQfKcZFMfA);

ODBC

CONNECT TO DMC_GIFTCARD (XUserId is fRNEeZFMLB, XPassword is

NNdaeQZOSBMKTZAGAH);

LOAD

"DATE_KEY"

"STORE_KEY"

"SEQUENCE_KEY"

"GC_THIRD_PARTY_FLAG"

"GC_BUY_OR_REDEEM"

"GC_CARD_NUMBER"

"GC_AMOUNT"

"GC_BALANCE"

"GC_AUTH_TYPE"

"GC_TRANS_TIMESTAMP"

"GC_TRANS_ID"

"GC_ACTIVATION_TYPE"

FROM

C:\qlikview_Old\Swetha\GIFT_CARD.qvd(qvd)

;

LEFT

JOIN

LOAD

GC_CARD_NUMBER, REDEEM_AMT, REDEEM_YEAR, REDEEM_MONTH,

GC_BALANCE1

FROM

C:\qlikview_Old\Swetha\OUT_BALANCE.qvd(qvd

)

where

exists(GC_CARD_NUMBER)

;

LEFT

JOIN

LOAD

ACTYEAR , ACTMONTH

Act_Total

FROM

C:\qlikview_Old\Swetha\ACTYEAR.qvd(qvd)

;

pls suggest

Tue, 05 Apr 2011 19:10:17 GMT

Hi,

You didnt shared data of table..just let me know the size of each tables and how many rows you are fetching

Apart from that I hope the issues because of

1.You fetching data irectly from data base,it may slow down your application.

Try to createqvds then pull data from there

2.Logic behind "Left Join" ,It may slow down the application.

3.If possible use if conditions in back end for caluclated dimension

Let me know for further uery

Thanks & Regards

Jai