Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
HalloQlik
Contributor
Contributor

Set Analysis but without sum etc.

Hello!

i have a list of absences (dimensions) from a HR tool. The table should not be truncated by the selection. However, the list is always filtered by date witch is selected. 
I have really tried a lot:

- ({1} AbsenseReason.Name)
- =({<[%Date] = {"$>=39448"} >}[AbsenceReason.name])

About like this in a thousand variations.

Can you guys help me? Thanks a lot!

Labels (1)
2 Replies
MayilVahanan

HI

Name field can't able to sum.

You can use Only() function if you have unique value for the row.
Else try with MaxString or MinString 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
MendyS
Partner - Creator III
Partner - Creator III

HI

try MaxString() and P() function in set analysis