Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bob_zagars
New Contributor II

Set Analysis with Dimension as Lookup

Hi,

I need help with a Set Analysis formula.  In this example I have a dimension in the Display table that I am trying to get a count within the Detail table about how many exist.  I can get the count if I hard code the codes and is shown in the text objects.  In the straight table I can use the Only function to get the dimension Code but inserting into a Set Analysis expression the correct answer does not appear.

Can anyone figure out how I can make my counts come out correctly?

Thanks in advance,

Bob

Tags (1)
2 Replies
MVP
MVP

Re: Set Analysis with Dimension as Lookup

maybe

Count(DISTINCT if(Item=Code, [Acct Number]))

bob_zagars
New Contributor II

Re: Set Analysis with Dimension as Lookup

Maxgo,

Thanks that works but I figure there is a Set Analysis solution.

Bob