Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kamal_sanguri
Specialist
Specialist

Set analysis to get only values where len is greater than 1

Hi All,

I am creating a straight table the data is in excel and has some blank cells.. In my straight table I do not want to show blank items.

I know I can filter them out with WHERE clause in script itself... however trying to learn how it can be done with SET ANALYSIS.

Here is something which I am trying:

only({1 <len(Description) = {">1"}> } Description)

Any help on this would be highly appreciated.

Thanks,

Kamal

1 Solution

Accepted Solutions
jerem1234
Specialist II
Specialist II

try:

only({1<Description = {"=len(trim(Description)) >=1"}>} Description)


-trim will remove any spaces to count them as blanks as well


Hope this helps!


View solution in original post

6 Replies
jerem1234
Specialist II
Specialist II

try:

only({1<Description = {"=len(trim(Description)) >=1"}>} Description)


-trim will remove any spaces to count them as blanks as well


Hope this helps!


View solution in original post

mov
Champion III
Champion III

Try

only({1 <Description = {"=len(Description)>1"}> } Description)

kamal_sanguri
Specialist
Specialist
Author

just one word....

AWESOME

kamal_sanguri
Specialist
Specialist
Author

sure.. it helped.... thanks much

Cheers,

Kamal

kamal_sanguri
Specialist
Specialist
Author

If you can elaborate it more...

why did we use "Description =" then criteria..

only({1<Description = {"=len(trim(Description)) >=1"}>} Description)

mov
Champion III
Champion III

Because in set modifier we specify field and selection criteria for this field.  That is

Field = {...}

We cannot use an expression in place of field.