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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Records Fetching

Hi All,

I have a table like belo from that I want to retrieve only

ID1NamePlacePhone
1A4587
1AC1245
1AD1254
2B4567
2BE4585
2BF4526

1,A,,4587

2,B,,4567

how to get those records.

Regards

John

2 Replies
sunny_talwar

Is the logic is to fetch those records where place is empty?

sunny_talwar

This:

Capture.PNG

Uncheck 'Suppress Zero-Values' on Presentation Tab

HTH

Best,

Sunny