topic Negation in set analysis in QlikView

Negation in set analysis

shanky1907 — Fri, 15 Nov 2024 23:38:39 GMT

Hello All,

I am working on one solution where I have to implement one straight table With Date & UserID as first two columns.

Now, I have one button from which one value(Value1) is passed on selection.

So for my UserID i have to use Calculated Dimension as:

=If(Value1='Y', Only({<UserID -= {"Field1=Y OR Field2 =Y "} UserID>}), UserID)

I am sure that above syntax in incorrect but the logic should be that way. Can you please help.

Re: Negation in set analysis

tresB — Thu, 12 Nov 2020 06:47:27 GMT

@shanky1907

Could you prepare a sample app and share here explaining the expected output in that context?

Re: Negation in set analysis

shanky1907 — Thu, 12 Nov 2020 07:00:31 GMT

I cant post an app currently. The Output should be Total population but removing UserIDs where Field1=Y & Field2=Y when Value1=Y otherwise it should contain whole population.

Re: Negation in set analysis

tresB — Thu, 12 Nov 2020 07:15:56 GMT

@shanky1907

As per your expression, you could try something like:

=If(Value1='Y', Aggr(Only({<UserID = e({<Field1={Y}>+<Field2 ={Y}> })>}, UserID),UserID), UserID)

Re: Negation in set analysis

edwin — Thu, 12 Nov 2020 17:19:35 GMT

or add a similar calculation in EXPRESSION instead of a calculated dimension and hide the column:

=if(Value='Y',
sum({<UserID=e( {<Field1={'Y'}> + <Field2={'Y'}>}UserID)>}1),
sum(1))

and add UserID as a dimension