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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
arnoqlik
Contributor III
Contributor III

Interest of listing fields in the modifier of a Set Analysis

Hello,

I slowly learn how to use Set Analysis.

While I did understand the interest of the modifier to filter data (example :  {$<Year={2021}>} ), I don't see what is the interest of listing fields in the modifiers.

Example:

 

Count({$<DATE_PIC_MONTH,
TYPE_BESOIN_PIC_DESCRIPTION,
%MATERIAL_PIC>}
DISTINCT EKPO.EBELP&EKKO.EBELN)

 

How to read this code?

Thank you.

 

EDIT: if I'm not wrong I think it means that we don't care about the (potential) selections in these fields.

For instance "DATE_PIC_MONTH" can be selected to the value "April" but the result of the set analysis will take into account the 12 months of the year.

Labels (1)
1 Reply
sergio0592
Specialist III
Specialist III

Hi,

The interest of listing field is to ignore selection on these fields. Take a look here, mainly explanations from S.Talwar

https://community.qlik.com/t5/QlikView-App-Development/Set-analysis-ignore-the-selection/td-p/114358...