Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

variable

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

1 Solution

Accepted Solutions
jayanttibhe
Creator III
Creator III

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

View solution in original post

1 Reply
jayanttibhe
Creator III
Creator III

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