topic Re: Field=field set analysis does not work in QlikView

Field=field set analysis does not work

gmenoutis — Tue, 15 May 2018 10:29:50 GMT

I have Fields TranId,StoreID,negStoreID in my model. The first two are members of the same table and thus connected, whereas negStoreID has no connection (I created it as a data island). If I want to only show TranIds that have a StoreID belonging in the current selections of negStoreID, I have to create a calculated dimension as follows:

aggr(only({<StoreID=P({$<StoreID=negStoreID>} StoreID)>}TranId),TranId)

Let me put the aggr and only out , since my question regards set analysis itself and not the trick on how to use it in the conditional dimension:

{<StoreID=P({$<StoreID=negStoreID>} StoreID)>} TranId

Why does the following not work in its place:

{<StoreID=negStoreID>} StoreID)>} TranId

Everywhere I've searched these forums I've seen the P solution proposed, and since it works, OPs are happy to end it there. But the syntax needed is much more complicated.

If there is an answer to this, please also include the following the exclude version::

{<StoreID-=negStoreID>} StoreID)>} TranId

instead of

aggr(only({<StoreID=E({$<StoreID=negStoreID>} StoreID)>}TranId),TranId)

Re: Field=field set analysis does not work

gmenoutis — Tue, 15 May 2018 10:33:26 GMT

alright, I was missing a { . Can a mod please delete this

Re: Field=field set analysis does not work

felipedl — Tue, 15 May 2018 12:57:31 GMT

Hi George,

You can delete the post on the right side, there's a "Delete" button under "Actions".

Re: Field=field set analysis does not work

gmenoutis — Tue, 15 May 2018 13:00:04 GMT

If I try, I get a white page saying Unauthorized in big letters and much technical jargon in small.

Re: Field=field set analysis does not work

isingh30 — Tue, 15 May 2018 13:40:41 GMT

Can you share you data or sample application?

Thanks