Discussion board where members can get started with QlikView.
I have one Field Say
i want output only ABCDE,EFGHI
Is this something you need in the script?
Also look here
Find the value by using wild match
WHERE NOT EXISTS ("*");
SQL SELECT .....;
Or this? May be:
IF(FindOneOf(Number, '*') = 0, Number) AS NewNumber
IF(FindOneOf(Number, '*') < 1, Number) AS Values,
FindOneOf(Number, '*') AS Num INLINE [
LOAD F1 Where Index(F1,'*')=0;
LOAD * INLINE [
Yes I want to show value only without * ,Using wildMatch Function in Script
Try like this
] Where Not WildMatch(Replace(Number, '*', '@'), '*@*');
it works but I still don't understand why using wildmatch() for that filter...
No idea... might be an interview question because there has been couple of request for the same scenario....