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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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...