Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

monikarumplerov
New Contributor

selecting top location only????

hi

i have a list of companie, every company has a list of locations and every location has a list of work related problems. how can i make a table showing a breakdown of work related problems selecting the location with most problems only? i can not hard code the name of location to the expression as this will change from company to company and also on monthly basis.

i tried this: = only(if(aggr(Rank(Count(distinct incidentid)),ReportLocationName)=1,ProblemType)) but it will only give me the name of top location and when i try to implement it to the table, it comes up with error message that there is a problem in my expression.

any ideas?

ideally i would need something looking like this:

Location with most problems for X company:

PROBLEMS  INCIDENTIDs

problem1           9

problem2           5

problem3           3

problem4           1

thanks

Monika