This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
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
I think what you need is to look here
Recipe for a Pareto Analysis – Revisited
ok, but i need to select products, so select in field with Field = Product ID
and vTest need to be a % from Total Sales.
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.
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.