topic Re. :Locking / Freezing an expressions. in QlikView

Locking / Freezing an expressions.

Tue, 11 Jan 2011 11:48:40 GMT

Hello,

Im trying to create a table with 2 expressions. How ever i want 1 of those expersions to not change when i select different

dates. However the other should change. How can i lock 1 expression to not change with my current selection?

as you can see on the picture. When i select this month by expamle the first Realisatie should change but the second should stay @ 77,38%.

Any help?

Thanks you Luuk

Re. :Locking / Freezing an expressions.

martin59 — Tue, 11 Jan 2011 11:54:18 GMT

Hi,

You have to use Set Analysis like this exemple :

avg({1} Realisatie)

Re. :Locking / Freezing an expressions.

Tue, 11 Jan 2011 12:02:21 GMT

Hey martin thanks for your quick responce.

How ever im scared i dont fully understand what your saying.

could you be a bit more specific?

Locking / Freezing an expressions.

srinivasa1 — Tue, 11 Jan 2011 12:06:42 GMT

pls write set analysis like this

sum

({1} Realistie)

Re. :Locking / Freezing an expressions.

srinivasa1 — Tue, 11 Jan 2011 12:08:51 GMT

U can use set anaylysis like bellow for your experssion.

sum

({1} Sales) }

Re. :Locking / Freezing an expressions.

Tue, 11 Jan 2011 12:22:48 GMT

Hey thanks for your quick responce,

this doesnt seem to work for me.

When i create it it looks like this.

sum

({1} $(vBezettingsgraad))

You think its bugs cause i use a var?

Re. :Locking / Freezing an expressions.

martin59 — Tue, 11 Jan 2011 12:23:21 GMT

What is your expression for Realisatie ?

Re. :Locking / Freezing an expressions.

Tue, 11 Jan 2011 12:29:26 GMT

It is a quite long var.



 (SUM(IF(Bewerkingen.CODE > 1000, ProjectTime.TotaalUren))
 + Count(Distinct IF(Bewerkingen.CODE = 1000 ,Date))) /
 ( SUM(IF(Bewerkingen.CODE <> 0002 AND Bewerkingen.CODE <> 0012 AND Bewerkingen.CODE <> 0017 AND Bewerkingen.CODE <> 0018 AND Bewerkingen.CODE <> 0019 AND Bewerkingen.CODE <>
 0072 AND Bewerkingen.CODE <> 1000, ProjectTime.TotaalUren )) + Count(Distinct IF(Bewerkingen.CODE = 1000 ,Date)))

Re. :Re: Re. :Locking / Freezing an expressions.

martin59 — Tue, 11 Jan 2011 12:40:56 GMT

You can try this :


(sum({1<Bewerkingen.CODE={">1000"}>} ProjectTime.TotaalUren) +
 Count( {1<Bewerkingen.CODE={1000}>} Distinct Date)) /
(Sum({1<Bewerkingen.CODE-={0002,0012,0017,0018,0019,0072,1000}>} ProjectTime.TotaalUren)
+ Count({1<Bewerkingen.CODE={1000}>} Distinct Date))

<div></div>