Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
imrasyed
Partner - Creator II
Partner - Creator II

Not Exists in the front end

Hi Experts,

Is there any equivalent of  not exists function in front end.

4 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi,

What is the exact requirement ?

We use exist, not exist to check whether the data is already loaded or not. We can use set analysis likewise.

 

Thanks,

Ashutosh

imrasyed
Partner - Creator II
Partner - Creator II
Author

Hi Ashutosh,

I have resources whose compliance state depends on multiple plugins associated with it.And the table is at plugin level.One resource can have multiple plugins.

A resource is non-compliant if atleast one of the plugin is non-compliant based on condition.

Now upon selection of filters,the compliance state for the resource shd be determined and tagged,also rest of the records also do the compliance condition.The problem here is the rest of the records also include the resources which satify the filter.So these resources flow under both the record set.

What i want is the resources which got compliance state upon filtering  should not flow under rest of the records compliance test.?

imrasyed
Partner - Creator II
Partner - Creator II
Author

@AshutoshBhumkar 

can you please let me know how to use exists functionality using set analysis?

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi,

You can create flags on the basis of condition and use those flags in set analysis.

Could you share sample data and expected output ?