topic Re: Data types in QlikView

Data types

Wed, 15 Aug 2012 19:07:55 GMT

I have two fields that I'm trying to link in my script. Both are the 3 letter abbreviations of the months like 'Jan', 'Feb' and such.

When I link them I get double the months in a selection box with some of them right aligned(text data type) and some aligned right(number data type), I need them all to be number data type. I've tried using num() (that turns the "string" to an actual number), num#() and, date(). None of them works to give me linked months that work correltly in my charts. Any ideas?

Re: Data types

MayilVahanan — Wed, 15 Aug 2012 19:42:35 GMT

Use text() or date#() function.

Hope it helps

Re: Data types

Anonymous — Wed, 15 Aug 2012 19:44:02 GMT

may be you should assign values to monthfield (in string format)

load * inline

[

jan , 1

....

.....

dec,12

]

then link them it should work

Re: Data types

Tue, 21 Aug 2012 14:21:31 GMT

Sorry. I knew this should work. I just had an accidental link with another table in the two tables I was linking that was screwing this up.