Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

silambarasan
Contributor II

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)

Life is so rich, and we need to respect to the life !!!
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 II

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

Community Browser