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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sakthi266
Contributor III
Contributor III

Show data which is No Follow up record

Hi Team, 

           I need to show the id which is no follow up. Please refer below the attachment which i required. 

 

 

Labels (1)
1 Solution

Accepted Solutions
sakthi266
Contributor III
Contributor III
Author

Hi Dalton , 

        Thanks for the Reply but there may be possible that ID 1 will repeated with status new and Date = '12/05/2021'. That time we need to show 1, 2, 4 as well.   Attached for you reference. 

 

Thanks and Regards, 

Sakthivel.S

9843527174

 

 

Regards,

Sakthivel.S

9843527174

View solution in original post

2 Replies
Dalton_Ruer
Support
Support

Simply do a search for the values in the filter box. 

Seriously the Search Box is really smart. By that I mean you can use Fuzzy searches and Expression searches in addition to just searching for the text or numeric value. Check out all the options: https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Selections/Selection...

In your case all you have to do is type =Count(Date)<2 like in the image below

CountSearch.png

sakthi266
Contributor III
Contributor III
Author

Hi Dalton , 

        Thanks for the Reply but there may be possible that ID 1 will repeated with status new and Date = '12/05/2021'. That time we need to show 1, 2, 4 as well.   Attached for you reference. 

 

Thanks and Regards, 

Sakthivel.S

9843527174

 

 

Regards,

Sakthivel.S

9843527174