Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
hi
In QlikView most things are case sensitive, so I think the correct answer is:
Hi
you always need to close things off, so maybe the answer is:
Bye! ![]()
![]()
I think it would more correct to use this:
=If(Above(Entry) = 'Hi', 'Bye!')![]()
Or maybe
=If(Upper(Above(Entry)) = 'HI', 'Bye!')
just in case of those pesky people not using capitals ![]()
HI function is not available. Are you looking for a function to extract most significant (high- order) portion of integer class value?
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...
P.