Using snapshot "facts" with daily facts - Qlik Community

Report Inappropriate Content · ‎2010-04-23

I'm still somewhat new to Qlikview, and for the most part have been able to provide answers for the analysts using the package. But I now have a request that has me stumped.

Some background. The product being sold is clothing. The lowest level (e.g. UPC or SKU) is the style/color/size. Some reports roll the sizes into just the style/color, others roll up to just the style level. At that level a style has a description, belongs to a group, can be assigned to several different status groups, etc.

The fact table in this case is the shipments, recorded daily at the style/color/size level. The report I'm trying to create is at the style level. It is to show the weekly total shipment units for each of the last six weeks, the grand total shipments, and then a column with the available for sale (AFS) quantity. There is an AFS value for each style/color/size, and the values are updated every morning. I can do this in SQL.

An example of that output (sorry about the spacing, I couldn't figure out how to get this as a monospaced font):

GROUP STS STYLE DESCRIPTION WEEK6 WEEK5 WEEK4 WEEK3 WEEK2 WEEK1 TOTAL AFS
BUBBLE MESH N STYLE620 PANTY BUBL MSH 0 0 138 15 18 29 200 3
BUBBLE MESH P STYLE620 PANTY BUBL MSH 14 6 7 17 9 5 58 656
STRETCH MESH A STYLE150 PANTY STR MESH 95 95 101 34 75 65 465 3,268

But I can't get the same result in QV. Part of the problem is dealing with the AFS. Is that a fact table?. Or are the AFS quantities attibutes of the items. I have tried joining the AFS table to the product master, thinking then that I could do something like just sum the AFS quantities. All I got from that was the error in calculation message. I also tried adding a date field to the AFS table, with the date being set to the current date, and then concatenating the AFS table to the shipment facts table. But that created an AFS column, populated with nulls, for each of the past 6 weeks. I've also tried various aggregation functions, again with no luck.

I used the sample data to create a list box of calendar week ending dates, CALNDRWKEND, and a chart table (fast change types Pivot and Straight) with dimensions of GROUPNAME, SIZESTSCD, BASESTYLE, STYLEDESC1 and CALNDRWKEND. There is one expression SHIP UNITS, which is SUM(QTYSHIPPED). Partial sums are calculated for CALNDRWKEND. The above sample was for weeks ending 2010-03-06 through 2010-04-10.

At this point I don't know what to try next, and would welcome any suggestions. We are running version 9.00.7320.7 SR2

Oh, one other complication. The table is to show all styles with a non-zero AFS quantity, even if there were no shipments in the period selected.

After copying in all the code I realized that I could attach a document. So if I am doing this properly my test document will also be included.


Calendar:
Load * inline
[CALENDARID, CALNDRDATE, CALNDRWKEND
1885, '2010-02-28', '2010-03-06'
1886, '2010-03-01', '2010-03-06'
1887, '2010-03-02', '2010-03-06'
1888, '2010-03-03', '2010-03-06'
1889, '2010-03-04', '2010-03-06'
1890, '2010-03-05', '2010-03-06'
1891, '2010-03-06', '2010-03-06'
1892, '2010-03-07', '2010-03-13'
1893, '2010-03-08', '2010-03-13'
1894, '2010-03-09', '2010-03-13'
1895, '2010-03-10', '2010-03-13'
1896, '2010-03-11', '2010-03-13'
1897, '2010-03-12', '2010-03-13'
1898, '2010-03-13', '2010-03-13'
1899, '2010-03-14', '2010-03-20'
1900, '2010-03-15', '2010-03-20'
1901, '2010-03-16', '2010-03-20'
1902, '2010-03-17', '2010-03-20'
1903, '2010-03-18', '2010-03-20'
1904, '2010-03-19', '2010-03-20'
1905, '2010-03-20', '2010-03-20'
1906, '2010-03-21', '2010-03-27'
1907, '2010-03-22', '2010-03-27'
1908, '2010-03-23', '2010-03-27'
1909, '2010-03-24', '2010-03-27'
1910, '2010-03-25', '2010-03-27'
1911, '2010-03-26', '2010-03-27'
1912, '2010-03-27', '2010-03-27'
1913, '2010-03-28', '2010-04-03'
1914, '2010-03-29', '2010-04-03'
1915, '2010-03-30', '2010-04-03'
1916, '2010-03-31', '2010-04-03'
1917, '2010-04-01', '2010-04-03'
1918, '2010-04-02', '2010-04-03'
1919, '2010-04-03', '2010-04-03'
1920, '2010-04-04', '2010-04-10'
1921, '2010-04-05', '2010-04-10'
1922, '2010-04-06', '2010-04-10'
1923, '2010-04-07', '2010-04-10'
1924, '2010-04-08', '2010-04-10'
1925, '2010-04-09', '2010-04-10'
1926, '2010-04-10', '2010-04-10'
1927, '2010-04-11', '2010-04-17'
1928, '2010-04-12', '2010-04-17'
1929, '2010-04-13', '2010-04-17'
1930, '2010-04-14', '2010-04-17'
1931, '2010-04-15', '2010-04-17'
1932, '2010-04-16', '2010-04-17'
1933, '2010-04-17', '2010-04-17'
];

Shpfacts:
Load * inline
[CALENDARID, PRODUCTID, QTYSHIPPED, GROSSAMOUNT
1886, 117982, 6, 45.60
1886, 205113, 2, 20.42
1886, 117956, 6, 45.60
1886, 117995, 6, 45.60
1886, 118003, 6, 45.60
1886, 205114, 3, 30.63
1886, 205112, 3, 30.63
1886, 117990, 6, 45.60
1886, 117964, 6, 45.60
1887, 118003, 1, 7.60
1888, 117990, 22, 176.00
1888, 117956, 4, 32.00
1888, 150093, 3, 32.25
1888, 118003, 8, 64.00
1888, 150097, 1, 10.75
1888, 117995, 4, 32.00
1888, 117982, 6, 48.00
1888, 117964, 4, 32.00
1888, 150089, 2, 21.50
1890, 118003, 2, 16.00
1890, 117995, 2, 16.00
1890, 117982, 1, 8.00
1890, 117964, 4, 32.00
1890, 117956, 1, 8.00
1893, 150093, 2, 15.06
1893, 150097, 2, 15.06
1893, 150089, 1, 7.53
1894, 117956, 2, 15.20
1894, 117964, 2, 15.20
1894, 117990, 10, 76.00
1894, 118003, 17, 131.60
1894, 117995, 1, 7.60
1895, 150089, 1, 10.21
1895, 117995, 1, 7.60
1895, 117956, 1, 7.60
1895, 118003, 3, 23.20
1895, 117964, 1, 7.60
1895, 117990, 3, 23.20
1896, 117964, 2, 16.00
1896, 117982, 6, 40.02
1896, 117977, 3, 24.00
1896, 117995, 2, 16.00
1896, 118003, 7, 56.00
1896, 117956, 1, 8.00
1896, 117990, 10, 80.00
1897, 117964, 5, 40.00
1897, 117982, 2, 16.00
1897, 117956, 5, 40.00
1897, 117990, 6, 48.00
1897, 117995, 2, 16.00
1897, 118003, 3, 22.40
1901, 117982, 1, 8.00
1901, 118003, 1, 8.00
1901, 150097, 2, 21.50
1901, 216556, 1, 10.75
1901, 216554, 1, 10.75
1901, 150093, 1, 10.75
1901, 117990, 1, 8.00
1901, 150089, 2, 21.50
1901, 216555, 1, 10.75
1902, 205063, 2, 16.00
1902, 216556, 5, 53.75
1902, 150093, 2, 20.42
1902, 205065, 14, 112.00
1902, 117982, 7, 54.00
1902, 216555, 3, 32.25
1902, 117995, 5, 38.80
1902, 117964, 5, 38.40
1902, 118003, 6, 46.40
1902, 216554, 5, 53.75
1902, 117990, 7, 54.00
1902, 117956, 4, 30.80
1903, 117982, 7, 56.00
1903, 216556, 5, 53.75
1903, 118003, 6, 48.00
1903, 117990, 7, 56.00
1903, 117969, 2, 16.00
1903, 117995, 7, 56.00
1903, 117956, 7, 56.00
1903, 216554, 5, 53.75
1903, 117964, 5, 40.00
1903, 216555, 3, 32.25
1904, 117956, 1, 8.00
1904, 117995, 3, 24.00
1904, 216556, 52, 559.00
1904, 216555, 27, 290.25
1904, 117990, 2, 16.00
1904, 118003, 1, 8.00
1904, 216554, 30, 322.50
1907, 216555, 1, 10.75
1907, 216554, 1, 10.75
1907, 216556, 2, 21.50
1908, 117969, 6, 48.00
1908, 117956, 3, 22.80
1908, 117982, 2, 12.96
1908, 117964, 2, 15.20
1908, 117995, 1, 7.60
1908, 117977, 6, 48.00
1908, 150093, 2, 21.80
1908, 117990, 7, 53.20
1908, 150097, 1, 10.90
1908, 118003, 7, 53.60
1909, 216556, 5, 53.75
1909, 216554, 3, 32.25
1909, 216555, 3, 32.25
1910, 150093, 2, 21.50
1911, 150099, 1, 10.75
1911, 150097, 4, 43.00
1911, 150093, 4, 43.00
1911, 150089, 3, 32.25
1915, 117964, 13, 95.20
1915, 150097, 1, 10.75
1915, 216556, 1, 10.75
1915, 150089, 1, 10.75
1915, 117956, 5, 40.00
1915, 117982, 15, 120.00
1915, 117990, 13, 100.00
1915, 118003, 6, 48.00
1915, 117995, 13, 104.00
1915, 150093, 1, 10.75
1916, 117982, 1, 7.60
1916, 150097, 2, 20.42
1916, 117990, 1, 7.60
1916, 216554, 2, 21.50
1916, 117995, 1, 7.60
1916, 216556, 1, 10.75
1916, 150089, 1, 10.21
1917, 117982, 1, 8.00
1917, 117964, 2, 16.00
1917, 216556, 6, 61.26
1917, 117995, 2, 16.00
1917, 117990, 2, 16.00
1917, 150093, 3, 32.25
1917, 216555, 4, 40.84
1917, 216554, 4, 40.84
1921, 117995, 2, 15.20
1921, 117990, 2, 16.00
1922, 216556, 2, 21.50
1922, 216554, 11, 118.25
1924, 118003, 7, 56.00
1924, 216556, 1, 10.75
1924, 117964, 3, 24.00
1924, 117995, 6, 48.00
1924, 117956, 4, 32.00
1924, 117990, 7, 56.00
1924, 117977, 2, 16.00
1924, 117982, 7, 56.00
1925, 118003, 3, 22.80
1925, 216556, 6, 64.50
1925, 150093, 5, 54.50
1925, 216555, 4, 43.00
1925, 117990, 8, 60.80
1925, 117956, 5, 38.80
1925, 117964, 6, 45.60
1925, 117982, 2, 15.60
1925, 117995, 1, 8.00
1925, 216554, 5, 53.75
];

Products:
Load * inline
[PRODUCTID, GROUPNAME, SIZESTSCD, BASESTYLE, STYLEDESC1, NRFCOLORNAME, NRFCOLOR, SIZE
 47552, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, XS
 47553, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTBK, 002, XS
 47554, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, XS
 47555, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, XS
 47556, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, XS
 47557, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, XS
 47558, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, XS
 47559, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, XS
 47560, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTCA, 811, XS
 47561, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, XS
 47562, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, S
 47563, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, S
 47564, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKRR, 004, S
 47565, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKDT, 008, S
 47566, STRETCH MESH, A,STYLE150, PANTY STR MESH, SNOGG, 103, S
 47567, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, S
 47568, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, S
 47569, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, S
 47570, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, S
 47571, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
 47572, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, M
 47573, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, M
 47574, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKRR, 004, M
 47575, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKDT, 008, M
 47576, STRETCH MESH, A,STYLE150, PANTY STR MESH, SNOGG, 103, M
 47577, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, M
 47578, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, M
 47579, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, M
 47580, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, M
 47581, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
 47582, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, L
 47583, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, L
 47584, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKRR, 004, L
 47585, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKDT, 008, L
 47586, STRETCH MESH, A,STYLE150, PANTY STR MESH, SNOGG, 103, L
 47587, STRETCH MESH, A,STYLE150, PANTY STR MESH, GRNFL, 304, L
 47588, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, L
 47589, STRETCH MESH, A,STYLE150, PANTY STR MESH, PNKFL, 660, L
 47590, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, L
 47591, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
117952, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKGH, 001, L
117953, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, L
117954, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, L
117955, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, L
117956, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, L
117957, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, L
117958, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, L
117959, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, L
117960, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, L
117961, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLSHD, 451, L
117962, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, L
117963, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, L
117964, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
117965, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKGH, 001, XS
117966, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTBK, 002, XS
117967, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, XS
117968, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, XS
117969, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, XS
117970, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, XS
117971, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, XS
117972, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, XS
117973, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, XS
117974, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLSHD, 451, XS
117975, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, XS
117976, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTCA, 811, XS
117977, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, XS
117978, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKGH, 001, M
117979, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, M
117980, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, M
117981, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, M
117982, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, M
117983, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, M
117984, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, M
117985, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, M
117986, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, M
117987, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLSHD, 451, M
117988, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, M
117989, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, M
117990, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
117991, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKGH, 001, S
117992, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, S
117993, STRETCH MESH, A,STYLE150, PANTY STR MESH, FLPBL, 003, S
117994, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKRR, 004, S
117995, STRETCH MESH, A,STYLE150, PANTY STR MESH, BKDOT, 007, S
117996, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKDT, 008, S
117997, STRETCH MESH, A,STYLE150, PANTY STR MESH, BBBLK, 009, S
117998, STRETCH MESH, N,STYLE150, PANTY STR MESH, SNOGG, 103, S
117999, STRETCH MESH, N,STYLE150, PANTY STR MESH, GRNFL, 304, S
118000, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLSHD, 451, S
118001, STRETCH MESH, N,STYLE150, PANTY STR MESH, PNKFL, 660, S
118002, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTCA, 811, S
118003, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
138485, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, L
138486, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
138487, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, M
138488, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
138489, STRETCH MESH, A,STYLE150, PANTY STR MESH, DOTBK, 002, S
138490, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
138491, STRETCH MESH, N,STYLE150, PANTY STR MESH, DOTBK, 002, XS
138492, STRETCH MESH, N,STYLE150, PANTY STR MESH, BCHNT, 966, XS
150089, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BLACK, 001, L
150090, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, DALIA, 429, L
150091, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, LROSE, 654, L
150092, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BBGUM, 663, L
150093, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BLACK, 001, M
150094, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, DALIA, 429, M
150095, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, LROSE, 654, M
150096, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BBGUM, 663, M
150097, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BLACK, 001, S
150098, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, DALIA, 429, S
150099, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, LROSE, 654, S
150100, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, BBGUM, 663, S
158746, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, S
158747, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, M
158748, STRETCH MESH, N,STYLE150, PANTY STR MESH, BCHNT, 966, XS
158749, STRETCH MESH, A,STYLE150, PANTY STR MESH, BCHNT, 966, L
192995, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKBH, 005, XS
192996, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, M
192997, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, L
192998, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, S
205063, STRETCH MESH, A,STYLE150, PANTY STR MESH, PPROS, 662, M
205064, STRETCH MESH, A,STYLE150, PANTY STR MESH, PPROS, 662, L
205065, STRETCH MESH, A,STYLE150, PANTY STR MESH, PPROS, 662, S
205066, STRETCH MESH, N,STYLE150, PANTY STR MESH, PPROS, 662, XS
205112, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, POOLP, 440, S
205113, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, POOLP, 440, L
205114, BUBBLE MESH , P,STYLE620, PANTY BUBL MSH, POOLP, 440, M
212333, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, L
212334, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, S
212335, STRETCH MESH, A,STYLE150, PANTY STR MESH, BLKBH, 005, M
212336, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKBH, 005, XS
214399, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, DALIA, 429, M
214400, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, BBGUM, 663, M
214401, BUBBLE MESH , A,STYLE620, PANTY BUBL MSH, DALIA, 429, S
214402, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, BBGUM, 663, S
214403, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, DALIA, 429, L
214404, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, BBGUM, 663, L
216489, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, XS
216490, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, S
216491, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, M
216492, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLUBB, 466, L
216554, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CNTLP, 810, S
216555, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CNTLP, 810, L
216556, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CNTLP, 810, M
230399, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, XS
230400, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, S
230401, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, M
230402, STRETCH MESH, N,STYLE150, PANTY STR MESH, BLKFF, 010, L
244851, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, M
244852, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, S
244853, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, XS
244854, STRETCH MESH, N,STYLE150, PANTY STR MESH, BOBLK, 011, L
244910, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CHINA, 271, M
244911, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, REDRJ, 617, M
244912, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CHINA, 271, S
244913, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, REDRJ, 617, S
244914, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, CHINA, 271, L
244915, BUBBLE MESH , N,STYLE620, PANTY BUBL MSH, REDRJ, 617, L
];

AFS:
Load * inline
[PRODUCTID, AFS
 47557, 0
 47559, 0
 47560, 0
 47561, 0
 47563, 0
 47564, 0
 47565, 0
 47566, 0
 47567, 0
 47569, 0
 47570, 0
 47571, 0
 47573, 0
 47574, 0
 47575, 0
 47576, 0
 47577, 0
 47579, 0
 47580, 0
 47581, 0
 47583, 0
 47584, 0
 47585, 0
 47586, 0
 47587, 0
 47589, 0
 47590, 0
 47591, 0
 117952, -4
 117953, 0
 117954, 0
 117956, 322
 117958, 0
 117961, 0
 117963, 0
 117964, 449
 117965, 0
 117967, 0
 117969, 101
 117971, 0
 117974, 0
 117977, 127
 117978, -8
 117979, 0
 117980, 0
 117982, 512
 117984, 0
 117987, 0
 117989, 0
 117990, 679
 117991, -8
 117992, 0
 117993, 0
 117995, 442
 117997, 0
 118000, 0
 118002, 0
 118003, 678
 138485, 0
 138486, 0
 138487, 0
 138488, 0
 138489, 0
 138490, 0
 158746, 0
 158747, 0
 158749, 0
 192995, 0
 192996, 0
 192997, 0
 192998, 0
 205063, 0
 205064, 0
 205065, 0
 205066, 0
 212333, 0
 212334, 0
 212335, 0
 216489, 0
 216490, 0
 216491, 0
 216492, 0
 230399, -1
 230400, 12
 230401, 8
 230402, 4
 244851, 24
 244852, 24
 244853, -17
 244854, 2
 150089, 161
 150090, 0
 150091, 0
 150092, 0
 150093, 310
 150094, 0
 150095, 0
 150096, 0
 150097, 190
 150098, 0
 150099, 1
 150100, 0
 205112, 0
 205113, 0
 205114, 0
 214401, 0
 216554, 0
 216555, 0
 216556, 6
 244910, 0
 244911, -1
 244912, 0
 244913, -1
 244914, 0
 244915, -1
 ];