Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Did you mean:
Creator

## Set Analysis for len function

Hi guys,

Can anyone tell me how can I write this expression in set analysis?

Count( distinct {<[Date]-={'NULL'}>} if( len([Date])>0 ,[Date]&[Dimension_1]&[Dimension_2]   ,null()))

I have tried this but this gives me a different count:

Count( distinct {<[Date]-={'NULL'},[Date]={"=len(trim([Date]))>0"}>} [Date]&[Dimension_1]&[Dimension_2])

Labels (6)

• ### Set Analysis

1 Solution

Accepted Solutions

Perhaps this?

Count( distinct {<[Date]-={'NULL', "=len(trim([Date]))<0"}>} [Date]&[Dimension_1]&[Dimension_2])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
2 Replies

Perhaps this?

Count( distinct {<[Date]-={'NULL', "=len(trim([Date]))<0"}>} [Date]&[Dimension_1]&[Dimension_2])

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator
Author

Thanks so much! @Anil_Babu_Samineni