7 Replies Latest reply: Apr 10, 2013 3:42 PM by Frank Hartmann

# 3 dimensional chart

hi guys,

i´m a newbie on qlikview and i need your help

for example if i have a excel file  with rawdata. the fields are:

idcountryused_function#clicks
01germanywrite5
02spainwrite4
04usawrite8
07italywrite11
10germanywrite4
12usawrite15
13francewrite2

but there are alot more values in the tables. now i want to make a 3d bar chart with countries on the x-axis, sum of  #clicks in the four intervals; x<5, x>=5 and <10, x>=10 and <15, x>=15 on the y-axis and the intervals itself as the z-axis.

sould look like this:

but if i try to rebuild the excelchart in qlikview it looks like this:

so my problem is that the rows are only duplicated. but for example i need the yellow bar in front position the blue bar in second position the green in third position

and the red one in last position and not stacked!!

hope you understand my problem and can help me!!!

• ###### Re: 3 dimensional chart

A 3D bar chart is very colorful and flashy, but also very hard to read correctly. You're probably better off using the Trellis option. See attached qvw for a 3D chart and the trellis example.

• ###### Re: 3 dimensional chart

Another option is to use block chart, it is quite readable with three dimensions.

Regards,

Michael

• ###### Re: 3 dimensional chart

is there another possibility instead of the class command? because i wanted to show x<10, x>=10 and x<30, x>=30 and <50, x>=50

with the class command i only have the choice between constant intervals, here i need to show interval=10, interval=20, intervall=20, and then the rest

• ###### Re: 3 dimensional chart

Sure, you can use a nested if statement:

if( x <10, 'x < 10',

if( x < 30, 'x >= and x < 30',

if( x < 50, 'x >= 30 and x < 50 ', 'x > 50')))

Or maybe you're looking for this.

• ###### Re: 3 dimensional chart

i red your post to late :D

• ###### Re: 3 dimensional chart

I used the dimensions Country and the calculated dimension:

=Aggr(if(count(Click)<2,1,if(count(Click)<3,2,if(count(Click)<4,3,4))),Country)

And it worked right

What are your dimensions and expressions?

• ###### Re: 3 dimensional chart

i found the solution to my problem!

i just add to the script:

If(#clicks<10, '<10', if(#clicks>=10 and #clicks<30,'>10 & <30', if (#clicks>=30 and #clicks<50,'>30 & <50','>50'))) as Interval

and then i use interval as my second dimension in the chart!!