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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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