topic Re: 3 dimensional chart in QlikView

3 dimensional chart

Frank_Hartmann — Tue, 09 Apr 2013 18:53:28 GMT

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:

id	country	used_function	#clicks
01	germany	write	5
02	spain	write	4
03	italy	read	9
04	usa	write	8
05	germany	read	6
06	portugal	read	3
07	italy	write	11
08	usa	read	15
09	france	read	12
10	germany	write	4
11	spain	read	19
12	usa	write	15
13	france	write	2
14	spain	read	6
15	germany	read	9

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

Gysbert_Wassenaar — Tue, 09 Apr 2013 19:13:49 GMT

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

eddysanchez — Tue, 09 Apr 2013 19:24:54 GMT

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

Anonymous — Tue, 09 Apr 2013 19:31:57 GMT

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

Regards,

Michael

Re: 3 dimensional chart

Frank_Hartmann — Tue, 09 Apr 2013 20:21:21 GMT

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

Gysbert_Wassenaar — Wed, 10 Apr 2013 08:00:33 GMT

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

Frank_Hartmann — Wed, 10 Apr 2013 10:18:02 GMT

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!!

Re: 3 dimensional chart

Frank_Hartmann — Wed, 10 Apr 2013 19:42:06 GMT

i red your post to late 😄