Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rishabhgoyal155
Contributor
Contributor

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

rishabhgoyal155
Contributor
Contributor
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%?

rishabhgoyal155
Contributor
Contributor
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