topic Set Analysis in Chart Expression in QlikView

Set Analysis in Chart Expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Quick question around set analysis.

I'm trying to create a chart with a single dimension (Grouping) and two expressions, one calculating the average of score across questions, where OptionID refers to a score from 1-5 and Question ID refers to the questions. Count(DISTINCT Name) counts the number of people who answered the question. This is the score for a specific Organisation (field) and only shows when one is chosen.

SUM(OptionID)/(Count(DISTINCT Name)*Count(QuestionID))

The above expression works fine.

I also want to create a static expression on the chart which stays the same no matter which Organisation is chosen (a static average across organisations). I have tried to use the following expression to no luck.

SUM({$<Organisation=>}OptionID)/(Count({$<Organisation=>}DISTINCT Name)*Count({$<Organisation=>}QuestionID))

Any help would be greatly appreciated - Thanks very much!

Re: Set Analysis in Chart Expression

sunny_talwar — Wed, 15 Jun 2016 16:18:19 GMT

I would have assumed this to work. The values in each of the row change based on selection in Organisation field?

Re: Set Analysis in Chart Expression

Thu, 16 Jun 2016 07:49:33 GMT

That's right - They should be staying static however.

Re: Set Analysis in Chart Expression

sunny_talwar — Thu, 16 Jun 2016 10:26:06 GMT

Do you have alternate states in your application? Can you may be share a sample to take a look at?