Discussion Board for collaboration related to QlikView App Development.
I have a complicated pivot table. It uses a lot of expressions from three tables, so it's getting me a headache..
In this table, I have a field called "Mes"(Month in Spanish), but I also have a selector for the same field.
I need to sum a value only for the selected months. For this, I'm using an expression like this:
The trouble with this, is that if I select more than one moth, the "total" line ignores the month.
I've tryied with this other condition:
if(Not(GetSelectedCount(Mes)>1 OR Not(IsNull(Mes))),
which works as expected, except that it ignores the non-selected months, and show me values for all months (like second image)
Can anybody help me please?
Finally I solved with this:
if(RowNo()>0 AND IsNull(Mes),
View solution in original post
The set analysis (in red) is telling QV to ignore selections in the Mes field. Just remove that from the expression.