Below is the query that I am trying to run in QlikView. It works perfectly fine in SQL, but it doesn't work in QV.
_________________________
ABC_TABLE:
SQL
SELECT Grid, COUNT([CUSTOMER ID]) FROM
(SELECT [CUSTOMER ID],AMOUNT_LCY, 'GRID' =
CASE
WHEN AMOUNT_LCY< 0 THEN 'DEBIT BALANCE'
WHEN AMOUNT_LCY>= 1 AND AMOUNT_LCY<= 100 THEN '1-100'
WHEN AMOUNT_LCY> 100 AND AMOUNT_LCY<= 500 THEN '100-500'
WHEN AMOUNT_LCY> 500 AND AMOUNT_LCY<= 1000 THEN '500-1000'
WHEN AMOUNT_LCY> 1000 AND AMOUNT_LCY<= 5000 THEN '1000-5000'
WHEN AMOUNT_LCY> 5000 AND AMOUNT_LCY<= 10000 THEN '5000-10000'
WHEN AMOUNT_LCY> 10000 AND AMOUNT_LCY<= 25000 THEN '10000-25000'
WHEN AMOUNT_LCY> 25000 AND AMOUNT_LCY<= 100000 THEN '25000-100000'
WHEN AMOUNT_LCY> 100000 AND AMOUNT_LCY<= 500000 THEN '100000-500000'
WHEN AMOUNT_LCY> 500000 AND AMOUNT_LCY<= 1000000 THEN '500000-1000000'
WHEN AMOUNT_LCY> 1000000 AND AMOUNT_LCY<= 2000000 THEN '1000000-2000000'
WHEN AMOUNT_LCY> 2000000 AND AMOUNT_LCY<= 3000000 THEN '2000000-3000000'
WHEN AMOUNT_LCY> 3000000 THEN 'ABOVE-3000000'
ELSE 'Zero'
END
FROM BALANCE_TABLE
where CATEGORY in ('1001','1003','1006','1512','1517','1951','1960','3036','3193','3194','3195','3911','17278','17279','17288','17289','17574',
'1501','1507','4002','4003','4009','6001','6002','6003','6004','6005','6006','6007','6008','6009','6011','6012','6013','6019','6020',
'6024','17567','1015','1953','21001','21003','21004','21005','21006','21008','21009','21010','21011','21012','21014','21015')
AND update_Date = (select distinct MAX (UPDATE_DATE)
from BALANCE_TABLE)) AS DATA
GROUP BY Grid;
Store ABC_TABLE into ABC_TABLE.qvd;
Drop table ABC_TABLE;
____________________________
