topic Re: Independence to a field in QlikView

Independence to a field

Anonymous — Thu, 19 May 2016 16:00:39 GMT

Hello,

I would like to made an independence to the field Date for this formula, because it affect the result displayed:

And when the field Date is selected:

But it is not the good result.

The expression here:

=SUM(Value_AIR)/1000000

Do you have a solution please ?

Thanks in advance for your help,

Sébastien.

sunny_talwar — Thu, 19 May 2016 16:01:44 GMT

May be this:

=Sum({<Date = >}Value_AIR)/1000000

Essentially, by add {<Date = >}, you will be telling the expression not to change based on selections

Anonymous — Thu, 19 May 2016 16:12:05 GMT

Thanks a lot !