Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Frank_Hartmann
Master II
Master II

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
03italyread9
04usawrite8
05germanyread6
06portugalread3
07italywrite11
08usaread15
09franceread12
10germanywrite4
11spainread19
12usawrite15
13francewrite2
14spainread6
15germanyread9

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:

1.png

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

2.png

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
eddysanchez
Partner - Creator
Partner - Creator

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?

Anonymous
Not applicable

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

Regards,

Michael

Frank_Hartmann
Master II
Master II
Author

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

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Frank_Hartmann
Master II
Master II
Author

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

Frank_Hartmann
Master II
Master II
Author

i red your post to late 😄