topic Re: hi in QlikView

hi

Thu, 04 Dec 2014 12:49:02 GMT

Thu, 04 Dec 2014 13:05:42 GMT

stigchel — Thu, 04 Dec 2014 13:49:55 GMT

In QlikView most things are case sensitive, so I think the correct answer is:

Thu, 04 Dec 2014 13:52:10 GMT

you always need to close things off, so maybe the answer is:

Bye!

stigchel — Thu, 04 Dec 2014 13:55:43 GMT

jonathandienst — Thu, 04 Dec 2014 13:57:03 GMT

I think it would more correct to use this:

=If(Above(Entry) = 'Hi', 'Bye!')

Thu, 04 Dec 2014 14:03:18 GMT

Or maybe

=If(Upper(Above(Entry)) = 'HI', 'Bye!')

just in case of those pesky people not using capitals

Thu, 04 Dec 2014 14:12:35 GMT

HI function is not available. Are you looking for a function to extract most significant (high- order) portion of integer class value?

Peter_Cammaert — Thu, 04 Dec 2014 14:13:39 GMT

Alternately, if you would like this to be a script result, try:

VeryRawData:

LOAD * INLINE [

RecNr, Message

1, Hi

2, Bye!

];

Express:

LOAD RecNr, MsgBox(Message, 'Meeting Nr. ' & RecNr) AS Result

RESIDENT VeryRawData;

EXIT Script;

As an added bonus, there's a little bit of interaction as well...