topic Re: Textbox excluding values in QlikView

Textbox excluding values

Wed, 25 Nov 2020 16:16:04 GMT

hi,

I have textbox which needs to calculate on the basis on Month filter only. It can be done but point is that I have used following formula.

=Sum({<City={'Pune','Mumbai','Delhi'>}Population)

same formula I have used in particular chart expression ( dimension - Manager).

I want it should calculate the number in text box with same formula BUT SHOULD NOT CHANGE ONCE I CLICK ON DIMENSION IN CHART.

Thanks,

Narendra

Re: Textbox excluding values

sunny_talwar — Thu, 01 Jun 2017 14:21:22 GMT

So the value should not change based on selection in Manager field? May be this

=Sum({<City={'Pune','Mumbai','Delhi'}, Manager>}Population)

Re: Textbox excluding values

Thu, 01 Jun 2017 14:26:59 GMT

Thanks,

If I take dimension as a CITY and following formula for textbox

=Sum({<City={'Pune','Mumbai','Delhi'>}Population)

Then? what should we do ?

Thanks again.

Re: Textbox excluding values

sunny_talwar — Thu, 01 Jun 2017 14:29:33 GMT

Is the field name City or CITY? Make sure you are consistent and use the correct casing.... Also, you are missing a closing curly parenthesis.

=Sum({<City={'Pune','Mumbai','Delhi'}>}Population)

The above expression should not change when you make selection in City field

Re: Textbox excluding values

Thu, 01 Jun 2017 14:33:25 GMT

Sorry was typing mistake.

Thanks,

If I take dimension as a CITY and following formula for textbox

=Sum({<City={'Pune','Mumbai','Delhi'}>}Population)

Then? what should we do ?

Thanks again.

Re: Textbox excluding values

sunny_talwar — Thu, 01 Jun 2017 14:34:40 GMT

What are you trying to do?

Re: Textbox excluding values

Thu, 01 Jun 2017 14:37:18 GMT

Textbox should Sum of populations for 'Pune','Mumbai','Delhi' only which could not change if I click on charts dimension.

but dimension should show all the data of CITY

Re: Textbox excluding values

sunny_talwar — Thu, 01 Jun 2017 15:21:35 GMT

No idea what you mean brother....

Re: Textbox excluding values

neelamsaroha157 — Thu, 01 Jun 2017 15:35:29 GMT

For Text box use expression as suggested by stalwar1‌

=Sum({<City={'Pune','Mumbai','Delhi'}, Manager>}Population)

and for your chart keep your expression simply as

=Sum(Population)