variable

[upaliwije]

Hi Firends

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';

SET CODE=AA;

DEB:

SELECT deb_brn_code AS BCOD,deb_cla_code CLA_CODE,TO_CHAR(deb_deb_date,'MM-YYYY')PERIOD ,SUM(deb_total_amount)AMOUNT,

  COUNT(DISTINCT deb_deb_note_no)NOS FROM rc_t_debit_note

  WHERE TO_CHAR(deb_deb_date,'YYYY')>='2008'

  GROUP BY deb_brn_code,deb_cla_code,TO_CHAR(deb_deb_date,'MM-YYYY');

  store DEB INTO d:\QLIKVIEW\QVD\FACT_TABLE\VOLUME\CODE+DEBIT_NOTE.QVD;

drop table DEB;

After storing 'AA' into CODE variable I want store my QVD file as AADEBIT_NOTE.QVD  but from my above script i get a file CODE+DEBIT_NOTE.QVD as my QVD filre. Pls help me to correct it

[jayanttibhe · Accepted solution]

Hi Upali,

Please find attached QVW. This QVW will generate the said QVD  [AADEBIT_NOTE.QVD]  file in the same folder where QVW file is located.

You can change the QVD target location by changing the path as per your requirement.

Thanks

Jayant Tibhe