topic calculate with variable in QlikView https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232074#M83746 <HTML><HEAD></HEAD><BODY><P>your variable seems to be working fine, take out the code field from your count expression and things chop and change ... i suggest you play around with the expression a little, also a slider or calendar object will force the formatting of the value input into your variable. .. hope this helps</P></BODY></HTML> Fri, 24 Dec 2010 00:15:07 GMT 2010-12-24T00:15:07Z calculate with variable https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232071#M83743 <HTML><HEAD></HEAD><BODY><P></P><P>=sum(if(Dagboek\Code='69' and $(Begindatum) &lt; Voorraadmutatie\Boekingsdatum,Voorraadmutatie\AantalBij))</P><P></P><P>I made a variable called 'Begindatum' . What do i want. On my dashboard i want to fill in a Begindatum. It is a field date. And he has to count when Dagboek =69 and Begindatum&lt; Voorraadnutatie\Boekingsdatum, then i want a total of Vooraadmutatie\AantalBij.</P><P>I do something wrong it seems. Because i get always the same Total. The variable Begindate dom't work.</P><BR /><BR /></BODY></HTML> Thu, 23 Dec 2010 22:07:12 GMT https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232071#M83743 francisvandergr 2010-12-23T22:07:12Z calculate with variable https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232072#M83744 <HTML><HEAD></HEAD><BODY><P>Try without $():<BR />=sum(if(Dagboek\Code='69' and Begindatum &lt; Voorraadmutatie\Boekingsdatum,Voorraadmutatie\AantalBij))</P></BODY></HTML> Thu, 23 Dec 2010 23:02:27 GMT https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232072#M83744 Anonymous 2010-12-23T23:02:27Z calculate with variable https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232073#M83745 <HTML><HEAD></HEAD><BODY><P>I've tried that already. It doesn't work. I attached an example. As you see the column "counting" shows always 427. It must depends on the variable</P></BODY></HTML> Thu, 23 Dec 2010 23:11:21 GMT https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232073#M83745 francisvandergr 2010-12-23T23:11:21Z calculate with variable https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232074#M83746 <HTML><HEAD></HEAD><BODY><P>your variable seems to be working fine, take out the code field from your count expression and things chop and change ... i suggest you play around with the expression a little, also a slider or calendar object will force the formatting of the value input into your variable. .. hope this helps</P></BODY></HTML> Fri, 24 Dec 2010 00:15:07 GMT https://community.qlik.com/t5/QlikView/calculate-with-variable/m-p/232074#M83746 2010-12-24T00:15:07Z