Discussion board where members can get started with QlikView.
I am using a stored procedure that uses a case statement...
"SELECT s. [Customer No_],s. [Due Date],s. [Posting Date],'Ageing from Due/Date' =
DATEDIFF(day,s. [Due Date],@MyDate) <= 30 then '[0 - 30D Days]'..etc"
while I get results using these statements
LOAD [Customer No_],[Due Date],[Posting Date],[Name],[Document No_],[Amount] as Amount,
'Ageing from Due/Date', 'Ageing from Post/date';
I do not see results "categoried" by 'Ageing from Due/Date' ..
is there something special about the CASe statement??
SQL EXEC dbo.cust_ageing @MyDate = '$(MyDate)';
if you use arithmetic operators as part of the column names, those need to be escaped in database dependent way. It is easier to use names consisting only of letters, numbers and underscore
can you give me an example? what do you mean "in database dependent way"...?