topic Re: Sum of calculated expression from Chart in Text Box in QlikView

Sum of calculated expression from Chart in Text Box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

In the attached file, I need to get the Total of "80% Flag" (which is calculated in the table) in the Text Box(No. of Product Code with 80% Sales).

Could you please Help regarding the same?

The idea is if in anyway we can save the total in a variable and display that variable in the text box.

That variable should be updated on every change in selections.

Thanks in Advance

Rishabh

Re: Sum of calculated expression from Chart in Text Box

sunny_talwar — Fri, 23 Mar 2018 15:50:15 GMT

Check this out

Recipe for a Pareto Analysis – Revisited

Re: Sum of calculated expression from Chart in Text Box

Anonymous — Mon, 26 Mar 2018 05:20:08 GMT

Hi Sunny,

Thanks for the response but this still doesn't solve my problem. I am not able to get the value in the Text box.

Re: Sum of calculated expression from Chart in Text Box

sunny_talwar — Mon, 26 Mar 2018 09:03:13 GMT

Are you sure the value in the chart is correct, can you explain outside of QlikView how are you calculating your top 80%?

Re: Sum of calculated expression from Chart in Text Box

Anonymous — Mon, 02 Apr 2018 05:02:21 GMT

Hi stalwar1,

In the Excel file if you look for count of countries with 80% of sales.It is 8.

Also in the graph, if you keep only four columns: Country, sales, cumulative sales and 80% flag; it will show 7 which is 1 less than 8 because there is a less than condition in the graph.

Hence it is correct.

Re: Sum of calculated expression from Chart in Text Box

neelam31123 — Tue, 08 Jan 2019 07:36:40 GMT

Hi Dear,

Did you manage to find any solution for your query? I have a similar requirement recently.

Many thanks,

Neelam