Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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])

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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])

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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