Discussion Board for collaboration on QlikView Scripting.
I have a field in access that is a "text" format for year but it is all numbers. I cannot change my access dbase for reasons no need to go in to.
in the script I have the below. How do I tell qlikview to treat 'Fiscal Year' as a number and not text?
`Fiscal Quarter #`
`Fiscal Year and Quarter`
`Week # in FQ`
`Salesbook Cust Seg and Lic Type`
`Service Sales Type`
You'll usually get the behavior you want with QV without explicitly casting to num, but if you need to:
num("Fiscal Year") as "Fiscal Year"