Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
kanalavs
Contributor
Contributor

Rank in the bar chart

Hi Friends,

I am new to the community. I have the requirement to display bar chart based on highest priority.

If a person has priority 1 and 2 then we need to consider the priority based on the latest date.

Please help how to write the rank script for the bar chart. You can find the data below.

 

FruitPerson NoRankDate
AppleSXXXX1120180718
AppleSXXXX2120180925
AppleSXXXX3120181119
AppleSXXXX4120180625
AppleSXXXX4120181016
AppleSXXXX5120180108
AppleSXXXX6120180815
AppleSXXXX7120180813
AppleSXXXX7120180814
OrangeSXXXX1220180718
OrangeSXXXX6220180815
BananaSXXXX2320180925
BananaSXXXX6320180815
GrapeSXXXX1520180718
BananaSXXXX3320181026
GrapeSXXXX5520171124
OrangeSXXXX5220180101

 

Attached Sample of the chart:

 

11 Replies
kanalavs
Contributor
Contributor
Author

Hi Aiolos Zhao

i  have written the expression as follows but the outcome is similar like you. some of the persons are tagging   to both CA and DA. Please advise me how to restrict the persons. 

Dimension:

AGGR(FirstSortedValue([Action],RANK_Level),[C_ID])

 

Expression:

Count(distinct(C_ID))

uacg0009
Partner - Specialist
Partner - Specialist

Have you seen my qvw?
I said I add the data source for testing the expression, have you seen it?
I think my expression is what you want, if not, please tell me what you want using my data.