Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
silambarasan
Creator II
Creator 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
Anil_Babu_Samineni

Question not clear to me. May be this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

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

silambarasan
Creator II
Creator II
Author

No i am using qv 11

tresesco
MVP
MVP

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

antoniotiman
Master III
Master III

Maybe this could hel You

How to achieve aggr with sort in Qlikview 11.20?

Regards,

Antonio

effinty2112
Master
Master

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