topic Re: Set analysis without values in App Development

Set analysis without values

jorditorras — Wed, 23 Feb 2022 08:57:08 GMT

Dear Gurús,

I'm involved in a project that was developed by another other person and I have a question about a formula...

I see there's a Measure that is calculated in a similar way than Set Analysis but without any value in the dimensions. Like this:

(Sum
({<[According to the place_EN]=,
[According to the place_ES]=,
[According to the place_PL]=,
Type_EN=,
Type_ES=,
Type_PL=>}
[Employee hours / Contractors])

What is the meaning of adding dimensions in the formula with no value??

I checked in forums and Qlik help but didn't see any information...

Thanks in advance!!

Re: Set analysis without values

hic — Wed, 23 Feb 2022 09:06:25 GMT

They remove any selection that the user has made interactively.

You can find it in the example under "modifiers" on https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Re: Set analysis without values

chris_djih — Wed, 23 Feb 2022 09:22:17 GMT

It means any selections of this dimenson is ignored in the measure.

Re: Set analysis without values

anvalo00 — Wed, 23 Feb 2022 10:56:19 GMT

Hola Jorditorras,

Las dimensiones que indicas lo que hacen es no tener en cuenta las selecciones sobre ésos campos para calcular la suma.

Saludos