topic Re: Set Analysis with Dimension as Lookup in QlikView

Set Analysis with Dimension as Lookup

bob_zagars — Tue, 01 Mar 2016 15:40:03 GMT

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

Re: Set Analysis with Dimension as Lookup

maxgro — Tue, 01 Mar 2016 22:30:28 GMT

maybe

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

Re: Set Analysis with Dimension as Lookup

bob_zagars — Wed, 02 Mar 2016 14:36:01 GMT

Maxgo,

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

Bob