variable

upaliwije — Sun, 25 Dec 2016 03:37:35 GMT

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

Re: variable

jayanttibhe — Sun, 25 Dec 2016 04:13:59 GMT

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

topic Re: variable in QlikView

variable

Re: variable