topic How to make the static textbox in QlikView

How to make the static textbox

Mon, 26 Sep 2011 11:24:04 GMT

Guys,

I have a text box.I have to make it static

Currently what happens is depending on the selection the value in the textbox changes.

I want a constant value to be displayed in the textbox.

This value will be calculated using the below expression

=sum( {<Date={">=$(vBeginDate) <=$(vEndDate)"}>} Sales)

Regds,

Sona

Mon, 26 Sep 2011 11:30:16 GMT

if you dont want the selections to influence your expression as in the below expression a "1" should be added..

sum( {1<Date={">=$(vBeginDate) <=$(vEndDate)"}>} Sales)

Hope thats u want

its_anandrjs — Mon, 26 Sep 2011 11:34:31 GMT

Hi,

I think you have to use some think link

=sum({1} {<Date={">=$(vBeginDate) <=$(vEndDate)"}>} Sales)

HTH

Rgds

Anand