Expression without taking into account the current selections

[#1]

Hello, i need help with expressions and selections

if i do a selection as show the image, need see only the projects associed a the selection, but the requeriment say, we need see the values historic (fourth column) the proyects. Then i put in the expression created with set analisys, the year and month static, independent at selection:  sum({<Cod={3}, Year=, Month= >}Total).

The problem is that appear projects, as proyecto 3 and proyecto 5, that are not related at selection and this create doubts.

what will can do for only see Proyecto 2 and Proyecto 4 in this case?

Thanks you for help me!

Paulina

[adamdavi3s]

Hi Paulina,

Your projects must be associated on the last column as qlikview should automatically suppress any rows where there is no data.

You'd need to change the last column to exclude them

[sunny_talwar · Accepted solution]

May be try this

Sum({<Cod={3}, Year=, Month= >}Total) * Avg(1)

or

If(Column(1) > 0, Sum({<Cod={3}, Year=, Month= >}Total))

[#4]

Hi Sunny:

Perfect, this solved the problem

If(Column(1) > 0, Sum({<Cod={3}, Year=, Month= >}Total))

I was complicated but the solved was very easy

Thanks you!!