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: 
Anonymous
Not applicable

Finding NULLS in set analysis and Concat List

Hi All,

I have two tables Tab1 and Tab2. I want to use something like below concat formula in Button (Select in Field) to select all NULL values when there is selection in Year and Month

='('&concat(aggr(if(only({<PCatID = {1}>}CreationDate)< max({<PCatID={2,3,4}>} CreationDate),ItemID), ItemID),'|')&')'

Capture.PNGCapture1.PNG

johnwstalwar1hic

Thanks in advance,

BR,

SAK

1 Reply
sunny_talwar

I don't see creation date in your sample data. Would you be able to provide a sample with the expected output you are looking to get?