I got a problem with a specific object showing a detail order, invoice, product with expression of turnover, discout, quantity...
It's a quite huge table if you don't select an invoice nulber before you open the specific sheet. The result is, qlikview is going down for a moment before all orders, invoices, products appears. I can save my document with this pivot table reduced so as there is no problem of timeout.
My point is how to make a macro who reduce an specific object when you open the sheet concern.
You can use the "Conditional Calculation" in the properties of your chart so if there is no selection, it will show an error message (which you can customize). You have all data but it won't be showed until some selection is done.
IsNull() doesn't behave itself in 64-bit unless that's been changed in version 9, so I'd rewrite the calculation condition as len(getcurrentselections()). However, it would be easy to make a selection that still leaves you with a gigantic data set. Perhaps here you would instead want something like count(distinct Invoice)<100, or something along those lines as your calculation condition.
.png "Miguel_Angel_Baeyens"){kind=avatar}
