Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andreip21
Contributor III
Contributor III

select % from running Total

Hello all,

I want to automatically select some product_ids based on their cummulated % in Total Sales generated.

For example, if i want 80% (i will create a input in my script and a slider in the interface), the first 6 Product IDs will be selected.

If i want 50%, only the first two.

It will help me than to calculate a conversion rate only for the selected products.

How do i do that?

   

Product IDSalesRunning Total%
150027.5%
240049.6%
320060.6%
415068.9%
512075.5%
610081.0%
78085.4%
87589.5%
97093.4%
106096.7%
114098.9%
1220100.0%
6 Replies
shiveshsingh
Master
Master

Make a variable ..as vTest and then set action on button to select value with search string  ='>='& $(vTest)

one inputbox also to define value for vTest

shiveshsingh
Master
Master

small example Capture.JPG

sunny_talwar

I think what you need is to look here

Recipe for a Pareto Analysis – Revisited

andreip21
Contributor III
Contributor III
Author

ok, but i need to select products, so select in field with Field = Product ID

and vTest need to be a % from Total Sales.

How do i do that?

andreip21
Contributor III
Contributor III
Author

yeah, great article, but the expression doesn't work in my case because i have a 1GB QVW and any aggr in the interface is veeery slow.

Other solutions?

sunny_talwar

Can you pre-aggregate everything at the script level? That is the only other solution... but then you loose the dynamic nature of QlikView where the pareto change based on selections.