Discussion Board for collaboration on QlikView Scripting.
How to get first 80% count in text object in qlikview?
Message was edited by: Silambarasan M
Question not clear to me. May be this?
If(Count(Sales) <= 0..8, Sales)
If you are having qv 12.x, you can probably use sortable aggr() like: Recipe for a Pareto Analysis – Revisited
No i am using qv 11
Then I guess you have hit the limitation. Upgrade to 12.x
Maybe this could hel You
How to achieve aggr with sort in Qlikview 11.20?
There's maybe a workaround here. If you can create a straight table in a hidden sheet that returns the correct number of rows to answer your question then this macro:
ActiveDocument.Variables("vRowCount").SetContent chart.GetNoOfRows, true
Replace CH01 with the name of your chart.
Will put the number of rows into the variable vRowCount.
Of course you'll need to click a button or such like to run the macro and update the value of the variable if selections change.