Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar graphs

lets say i have two dimensions Places and  Accidents

but accidents have many fields say car accident, bike , bus, .......

i want to show a grouped chart with y axis as number of counts and x axis as places and TOP THREE ACCIDENT count

thanks in advance

4 Replies
sushil353
Master II
Master II

Hi,

Sort Descending Y and limit the dimension in dimension limits.

HTH

Sushil

vinay_hg
Creator III
Creator III

if u want to show on every place top three accidents then put place and accidents in dimention, take count in expression and in dimension limit for second dimensio, i.e. accidents put top3.

or

just u want only top 3 accident count irrespecttive of place then take only accidents in dimension count in exp. in dimension limit again top 3 for accident

aveeeeeee7en
Specialist III
Specialist III

Try Something like this:

Sum({<ACCIDENT= {"=rank(sum(Value))<= 3"}>} Value)

sudeepkm
Specialist III
Specialist III

please take a look at the attachment. let me know if you have any questions.