topic Re: Set Analysis in QlikView

Set Analysis

Wed, 11 May 2016 19:28:44 GMT

Good afternoon,

I have created my first Set Analysis in a Straight Table with the kind help of folks in the Community.

I am comparing data from one month to the next and showing the difference.

I would like to just show the difference above and below a certain number i.e. above 10,000 or less than 10,000.

Is there a straight forward way to do this or do I need to do this as part of the load?

Thank you

Re: Set Analysis

sunny_talwar — Wed, 11 May 2016 19:31:35 GMT

I think the scenario your mentioning might need you to use Above/Below function. You can learn about them here:

Missing Manual - Above() and Below()

Re: Set Analysis

rubenmarin — Wed, 11 May 2016 19:41:28 GMT

Hi Mitchell, check the attached document to see an example.

If I understand it right you will need two variables: one for operator and other for the value. In the expresion "Sum(V)" should be your actual expression.

In the Rules tab of the input box you can check how is configured the vCompareOperator variable

Re: Set Analysis

Wed, 11 May 2016 19:52:19 GMT

Thank you - please send the attachment

Re: Set Analysis

rubenmarin — Thu, 12 May 2016 07:10:33 GMT

Hi Mitchell, it's in the post above, this is the link: