Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
harish_meda
Contributor II
Contributor II

Null entry filed values need to be capture in a table

Hi All,

I want to display the SessiosnID value status in a table

Session Table:

 Session:
Ticket NumberSession ID
12311
12312
45613
689 

 

Incient :Table
TicketNumber
123
456
689

Result:

TicketNumberSession Status
123Available
456Available
689No
1 Solution

Accepted Solutions
QFabian
Specialist II
Specialist II

Hi @harish_meda , please try this :


Session2:
LOad
*,
if(isnull(SessionID) or SessionID='', 'No', 'Available') as Status
Resident Session;
drop table Session;

QFabian

View solution in original post

3 Replies
QFabian
Specialist II
Specialist II

Hi @harish_meda , please try this :


Session2:
LOad
*,
if(isnull(SessionID) or SessionID='', 'No', 'Available') as Status
Resident Session;
drop table Session;

QFabian

View solution in original post

harish_meda
Contributor II
Contributor II
Author

Hi,

Thanks for the solution.The above logic is giving status only Available.But your logic helps me think in another way.

But I have tried apply map it is working.

map:

Mapping load
Incident Number,
SessionID Resident Session Details;

Main:

IncidnetNumber,

applymap('map',IncidentNumber,'NotAvailable') as SessionAvailableStatus

Resident Incidents:

harish_meda_0-1617032551079.png

 

QFabian
Specialist II
Specialist II

perfect @harish_meda , i thought abou mapping, but just lookeed to Incient Table , and with just one field, mapp doesnt work

Good Job!

QFabian