Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
silambarasan
Contributor

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

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

Message was edited by: Silambarasan M

6 Replies

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

Question not clear to me. May be this?

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

MVP
MVP

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

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

silambarasan
Contributor

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

No i am using qv 11

MVP
MVP

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

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

antoniotiman
Honored Contributor III

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

Maybe this could hel You

How to achieve aggr with sort in Qlikview 11.20?

Regards,

Antonio

effinty2112
Honored Contributor

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

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