Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Shubham_Deshmukh
Specialist
Specialist

How to take actual values, not count?

I have some IDs and I want to show that values(ID) I am doing something like , If(D1> xyz and D2 < abc,ID) But I know this is wrong way. Can any1 tell me how to get IDs?

5 Replies
tresesco
MVP
MVP

Could you explain a bit more with a sample data set may be?

prma7799
Master III
Master III

Please share some sample data .... with expected output...

Shubham_Deshmukh
Specialist
Specialist
Author

Usually what we do in such cases, Count(If(D1> xyz and D2 < abc,ID)) then result will be count(ID). But now I want to print all ID comes under dates D1 and D2.

tresesco
MVP
MVP

This?

Concat(Distinct If(D1> xyz and D2 < abc,ID) , ',')

Shubham_Deshmukh
Specialist
Specialist
Author

Thanks Tresesco, I will try.