Discussion board where members can get started with QlikView.
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
Check this out
Recipe for a Pareto Analysis – Revisited
Thanks for the response but this still doesn't solve my problem. I am not able to get the value in the Text box.
Are you sure the value in the chart is correct, can you explain outside of QlikView how are you calculating your top 80%?
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.
Did you manage to find any solution for your query? I have a similar requirement recently.