Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
marcel_olmo
Partner Ambassador
Partner Ambassador

How to make this chart in Qlikview?

Hi guys, I have to make a bar chart based on an excel analysis.

The chart has to look like this :

Excel_BarChart_Biz_web.jpg

And I'm trying to figure it out how to do it in Qlikview. I'm trying to add new "fake" dimension in order to get a field called "pivotdimension" with values : CY, LY, Budget,... but I can't get the same result.

Any ideas?

Regards, Marcel.

1 Reply
miikkaqlick
Partner - Creator II
Partner - Creator II

Hi!

Sales:

Load * Inline [

SalesPer,    Time,    Sales

John,        CY,        10

Kim,        LY,        10

Dave,        BCY,    10

Peter,        BLY,    10

John,        BLY,        10

Kim,        CY,            10

Dave,        LY,            10

Peter,        BCY,        10

John,        BCY,        4

Kim,        BLY,        3

Dave,        CY,    12

Peter,        LY,    1

John,        BLY,        9

Kim,        BCY,        8

Dave,        CY,    8

Peter,        LY,    6

John,        LY,        6

Kim,        BCY,        5

Dave,        BLY,    4

Peter,        CY,    2

];

you don't need extra dimensions.

Br,

Miikka