topic Total Mode Value in textbox in QlikView

Total Mode Value in textbox

Athira_K — Fri, 25 Feb 2022 07:19:59 GMT

Hello,
I have a chart with expression and I want the value of the total Mode Sum of rows in a textbox
How can we implement it?

In this case I need 510.... to be displayed in a textbox

Thank you

Re: Total Mode Value in textbox

hic — Fri, 25 Feb 2022 08:58:57 GMT

In most cases, a normal Sum(X) will return the value you want. However, due to many-to-many relationships in the data model, the Sum(X) may be different from the sum of rows in a chart.

If you want to create a sum of rows in a text box, you need to define what a "row" is. Is it the value per e.g. Month, Product, Customer or Country? This is your iterator - your dimension - that you need to use in your expression. Once you have decided this, you can write your expression that should be based on an Aggr(), e.g.

=Sum(Aggr(Sum(X), Iterator))

Re: Total Mode Value in textbox

Athira_K — Fri, 25 Feb 2022 11:13:37 GMT

Thank you for helping
I tried aggr function,it is causing nested error.

Re: Total Mode Value in textbox

Hill69 — Fri, 04 Mar 2022 04:33:59 GMT

@Athira_K wrote: MyMercy.com

Hello,
I have a chart with expression and I want the value of the total Mode Sum of rows in a textbox
How can we implement it?

In this case I need 510.... to be displayed in a textbox

Thank you

Is it the value per e.g. Month, Product, Customer or Country?

Re: Total Mode Value in textbox

hic — Thu, 03 Mar 2022 09:10:24 GMT

As I said, you need to decide what you want to use as iterator - as "Row"-identifier - and then use this in

=Sum(Aggr(Sum(X), Iterator))

You say that this gives you an error, but since you haven't said what expression you tried, I cannot help you.

Re: Total Mode Value in textbox

jibagas402 — Mon, 21 Aug 2023 08:35:55 GMT

I don't know, this is clearly my web design Javascipt mode coming out of me even ... here is the easy way to get input filed value on click. Kahoot Login

Re: Total Mode Value in textbox

mayomayo72218 — Wed, 23 Aug 2023 08:13:13 GMT

This is a vague question. Can you give me more information?

Vampire Survivors