topic Re: Expression without taking into account the current selections in QlikView

Expression without taking into account the current selections

Thu, 09 Mar 2017 12:04:38 GMT

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

Re: Expression without taking into account the current selections

adamdavi3s — Thu, 09 Mar 2017 12:08:43 GMT

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

Re: Expression without taking into account the current selections

sunny_talwar — Thu, 09 Mar 2017 12:13:58 GMT

May be try this

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

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

Re: Expression without taking into account the current selections

Thu, 09 Mar 2017 12:39:03 GMT

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!!