Discussion Board for collaboration related to Creating Analytics for QlikView.
I have a question regarding to a where clause.
Here is my table
How must look my where clause that i get only back rows which an element is max 1 time in a row.
In the example above the correct result must be a/e/r and a/u/t.
May be this
Where SubField(Field, '/', 1) <> SubField(Field, '/', 2) and SubField(Field, '/', 1) <> SubField(Field, '/', 3) and SubField(Field, '/', 3) <> SubField(Field, '/', 2);
Here is a sample script using an inline load
LOAD * INLINE [
Thank you. But it there a solution with and / or?
Not sure what you mean? I have used and
another approach for variable number of elements
LOAD Field, SubField(Field, '/') as Word INLINE [
WHERE WordCount = WordCountDistinct;
Count(Word) as WordCount,
Count(DISTINCT Word) as WordCountDistinct
Group By Field;