# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
2 Replies

Perhaps this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Creator
Author

Thanks so much! @Anil_Babu_Samineni

Tags
Community Browser