Qlik Community

Ask a Question

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

cancel
Showing results for 
Search instead for 
Did you mean: 
Pdmotta
Contributor II
Contributor II

Preventive , something like "not exists" in SQL

In health insurance it´s very common the necessity to know with person didn´t attend to a certainly exam or medical procedure.

How can I do that ?

In set analysis we can use the E() but can I get this "inverse result" in a table ?

I hope this question is clear enougth.

 

Example 

NameExam
Marymammography 
Jonhpsa test
Labels (1)
5 Replies
Anil_Babu_Samineni

Question not clear for me, Sorry. Can you explain more?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Pdmotta
Contributor II
Contributor II
Author

Thanks for the answer Anil , I´m not sure that can be posssible ,  but I need a table of a "not set" , as in my example , "Mary" did not attend to a Mamography procedure.

Anil_Babu_Samineni

There should be some alternative option. Can you explain some more records and the expected result?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
marcus_sommer
MVP & Luminary
MVP & Luminary

Probably there is no easy way because I assume that there aren't any records for those data. In a classical analysis in Qlik you could see these missing exams through the color-coding of green, white and grey to the data-associations within the listboxes but you couldn't display them within a table because those data didn't exists.

Depending on your data, datamodel and requirements to show the information the enabling of the option to show null/zero within the object and/or creating synthetic dimensions and/or forcing a set analysis with {1} and/or adding further calculations in the object or similar measures may help to display those information. But it could become quite difficult and it has mostly some side-effects especially in regard to the usability and performance.

Especially if the related dataset isn't too large it's often easier to create the missing data within the script:

Generating-Missing-Data-In-QlikView 

- Marcus

Pdmotta
Contributor II
Contributor II
Author

Thanks , the trouble is the dataset IS too large , a general list of medical procedures of our regulatory agency.

Probally a set of Filters and The standard Colors (green and grays) will solve.