Discussion Board for collaboration on QlikView Scripting.
Reposted from "Community" site to "Developer" site:
I normally load directly from an SQL server and have been adding fields using a Case statement in the script. For example:
WHEN Term is null then 'No Term'
WHEN Term <=12 then '0-12'
WHEN Term >=13 and Term <=24 then '13-24'
WHEN Term >=25 and Term <=36 then '25-36'
End as term_band
I would like to create the same type of field when loading from an excel file. Something like this:
[Total Financed $],
(biff, embedded labels, table is Sheet1$);
If [Term] <= 36 then "0-36"
elseif 37 < [Term] <= 48 then "37-48"
Else "48+" as [Termband]
Go to Solution.
Do you really need two tables. You may load the termband in the same table as given below:
If (Term <= 36, '0-36',
If (Term <= 48, '37-48', '48+')) as Termband,