topic Re: OR Mode in Set Analysis in QlikView

OR Mode in Set Analysis

idodel — Sat, 16 Nov 2024 18:30:08 GMT

Hello! I have a bit problem with set analysis.

I need the measure to count the expression if one of the 2 fields "INCOME_PRICE" , "PRECENT_INCOME_PROJ" is greater than 0. (besides of all the other filters..)

and as I know, set analysis is like AND mode and not like OR mode.

how can I do that?

Thanks for all

Re: OR Mode in Set Analysis

Saravanan_Desingh — Thu, 11 Jun 2020 17:27:22 GMT

May be.

Count(DISTINCT {<FieldA={"=NCOME_PRICE > 0 Or PRECENT_INCOME_PROJ > 0"}>} FieldA)

Re: OR Mode in Set Analysis

skamath1 — Thu, 11 Jun 2020 18:20:03 GMT

Try something like

Count(DISTINCT { ( <INCOME_PRICE = {">0"}> + < PRECENT_INCOME_PROJ = {">0" }> ) } FieldA)

I have an expression in my data set that works. For me, I need to count records where Status2 = 1 or Status3 = 1.

Status2 and Status3 have data values of 0 and 1.

Count( { ( <Status2={1}> + <Status3={1}> ) } ID)

Re: OR Mode in Set Analysis

sergio0592 — Thu, 11 Jun 2020 18:28:10 GMT

Hi, try with :

Count(DISTINCT {<INCOME_PRICE = {">0"}> + <PRECENT_INCOME_PROJ = {">0" }>} FieldA)

Re: OR Mode in Set Analysis

idodel — Sun, 14 Jun 2020 08:16:14 GMT

Hey! thank you all for helping me.

At first I thought it solved the problem (when I filter on 1 project I saw 100%)

but then I cancel the filter and I saw over than 100% have the [INCOME_PRICE] OR [PRENECT_INCOME+PROJ] >0 , which is not possible.

Re: OR Mode in Set Analysis

idodel — Tue, 16 Jun 2020 11:16:00 GMT

I have tried to put in the measure:

if( [INCOME_PRICE] > 0 OR [PRENECT_INCOME_PROJ] > 0,

SOME SET ANALYSIS- WITHOUT THE PRICE FIELDS,

-when I do this all the projects are 0 from some reason.

what can I do ?

Re: OR Mode in Set Analysis

Brett_Bleess — Wed, 01 Jul 2020 21:15:07 GMT

You likely need to attach a sample QVW in this case in order to receive the help you need, as folks need to be able to see the data model and expressions in some cases in order to see what may be going wrong.

The only other place I can point you is to the Design Blog area:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

The Help may be good to review too:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Regards,
Brett