How to sort the values in front end dynamically and show the first 80% count in text object in qlikview?

[silambarasan]

How to get first 80% count in text object in qlikview?

Message was edited by: Silambarasan M

[Anil_Babu_Samineni]

Question not clear to me. May be this?

If(Count(Sales) <= 0..8, Sales)

[tresesco]

If you are having qv 12.x, you can probably use sortable aggr() like: Recipe for a Pareto Analysis – Revisited

[silambarasan]

No i am using qv 11

[tresesco]

Then I guess you have hit the limitation. Upgrade to 12.x

[antoniotiman]

Maybe this could hel You

How to achieve aggr with sort in Qlikview 11.20?

Regards,

Antonio

[effinty2112]

Hi,

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:

Sub GetRowCount()

set chart=ActiveDocument.GetSheetObject("CH01")

ActiveDocument.Variables("vRowCount").SetContent chart.GetNoOfRows, true

End sub

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.

Cheers

Andrew