Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum of calculated expression from Chart in Text Box

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

5 Replies
sunny_talwar

Anonymous
Not applicable
Author

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.

sunny_talwar

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

Anonymous
Not applicable
Author

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.excel.PNG

qlik Graph.PNG

neelam31123
Contributor
Contributor

Hi Dear,

 

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

 

Many thanks,

Neelam