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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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