topic Re: Bar graphs in QlikView

Bar graphs

Thu, 04 Sep 2014 10:09:12 GMT

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

Re: Bar graphs

sushil353 — Thu, 04 Sep 2014 10:14:04 GMT

Hi,

Sort Descending Y and limit the dimension in dimension limits.

HTH

Sushil

Re: Bar graphs

vinay_hg — Thu, 04 Sep 2014 10:51:14 GMT

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.

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

Re: Bar graphs

aveeeeeee7en — Thu, 04 Sep 2014 10:56:26 GMT

Try Something like this:

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

Re: Bar graphs

sudeepkm — Thu, 04 Sep 2014 11:29:39 GMT

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