Conditions in Set Analysis

Fri, 09 Sep 2016 10:04:21 GMT

I am having some trouble including a condition in my set analysis.

Goal: count the products id from my max month year ( it works), for a certain level type (also works), and for when the field value is greater than the 3% of the total value sum (with the same filters). This is where I am having trouble. The field value can be positive and negative, but I need to ignore it and just use absolutes, the fabs.

If I use the following set analysis, it will only give back the values ( not absolute values) that are grreater than the 3% of total value (colored in orange in the image), which is almost what i want, i just need to include the absolute values somewhere. It is counting 2 ids instead of 7 (see image):

=count({<

month={"$(=Max(month))"},

[Nivel 3]={'No explicadas'},

Valor={"> $(=sum({<month={'$(=Max(month))'},[Nivel 3]={'No explicadas'}>}fabs(Valor)) *0.03)"}

>}ID_operacion)

I have also tried the following set analysis, using the 3% of the total sum as a number, and it is counting the 7 ids.

=count({<month={"$(=Max(month))"},

[Nivel 3]={'No explicadas'},

Valor={"=fabs(Valor) > 2235184.339 "}

>}ID_operacion)

However, when i mix them both, they dont work:

=count({<month={"$(=Max(month))"},

[Nivel 3]={'No explicadas'},

Valor={"=fabs(Valor) > $(=sum({<month={'$(=Max(month))'},[Nivel 3]={'No explicadas'}>}fabs(Valor)) *0.03)"}

>}ID_operacion)

Any suggestions about how to solve this?

thanks!

topic Conditions in Set Analysis in QlikView

Conditions in Set Analysis