Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Partner
Partner

Field=field set analysis does not work

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)

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Field=field set analysis does not work

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

View solution in original post

4 Replies
Highlighted
Partner
Partner

Re: Field=field set analysis does not work

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

View solution in original post

Highlighted
Partner
Partner

Re: Field=field set analysis does not work

Hi George,

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

Highlighted
Partner
Partner

Re: Field=field set analysis does not work

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

Highlighted
Valued Contributor

Re: Field=field set analysis does not work

Can you share you data or sample application?

Thanks