Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

categories on dimension axe

Hi,

I’m new at QlikView and use the free version (QVPE – personal edition).

I want to create a diagram like this one (made in excel, see attachment).  

My problem is creating the categories on the dimension axe. Every category sums up the values in its ranges. How can I make these in a diagram without making any (complicated) entries in the script?

Thank you for your suggestions!

Regards

Martina

9 Replies
dennisnet
Valued Contributor III

categories on dimension axe

Hi Martina,

Welcom to Qlikview.

What you should use is a Bar Charts and set the sybtype (Tab Slyle) to Grouped.

That is the way to make a diagram as shown in your example.

If you need to know how to make it exacly please share your excel (are an example ) with us.

Good luck,

Dennis.

Not applicable

Re: categories on dimension axe

Hi Dennis,

unfortunately I cannot set the style to grouped – this section is grey.

Please see my example in excel; I attach it to this e-mail I hope that works. This excel example looks like my chart in Qlik View.

Thanks and regards

Martina

Von: Dennis Hoogenboom

Gesendet: Montag, 16. Mai 2011 15:50

An: Voigt, Martina__DE

Betreff: - Re: categories on dimension axe

QlikCommunity<http://community.qlik.com/index.jspa>

Re: categories on dimension axe

created by Dennis Hoogenboom<http://community.qlik.com/people/dennisnet> in New to QlikView - View the full discussion<http://community.qlik.com/message/116432#116432

dennisnet
Valued Contributor III

Re: categories on dimension axe

Hi Martina,

Is this what you are looking for?

See attachment:

Dennis.

Not applicable

Re: categories on dimension axe

Hi Dennis,

I can’t open the file; I use the free version. Could you post this as a picture or excel?

Martina

Von: Dennis Hoogenboom

Gesendet: Montag, 16. Mai 2011 17:41

An: Voigt, Martina__DE

Betreff: - Re: categories on dimension axe

QlikCommunity<http://community.qlik.com/index.jspa>

Re: categories on dimension axe

created by Dennis Hoogenboom<http://community.qlik.com/people/dennisnet> in New to QlikView - View the full discussion<http://community.qlik.com/message/116466#116466

dennisnet
Valued Contributor III

Re: categories on dimension axe

Sure.

Is this what you are looking for?

Martina.JPG

Not applicable

Re: categories on dimension axe

Hi Dennis,

this is very similar to what I already have I think. What would you do to show the values in categories, e.g. the sum of 0 until 5 on the x-axis as one value? And another value for 6-10 and so on?

Martina

Von: Dennis Hoogenboom

Gesendet: Montag, 16. Mai 2011 18:00

An: Voigt, Martina__DE

Betreff: - Re: categories on dimension axe

QlikCommunity<http://community.qlik.com/index.jspa>

Re: categories on dimension axe

created by Dennis Hoogenboom<http://community.qlik.com/people/dennisnet> in New to QlikView - View the full discussion<http://community.qlik.com/message/116467#116467

dennisnet
Valued Contributor III

Re: categories on dimension axe

I see what you mean.

What you need is an extra dimension.

The easiest way is to add a colom to your Excel file.

Some thing like GroupID : 0-5, 6-10, 11-15 etc.

Then add this group as a second dimension.

Not applicable

Re: categories on dimension axe

To build the diagram in Excel is no problem, but I’d like to switch my report (which consists of many of this diagrams and a lot more data) to qlik view to spend less time on it…

I created a file like that to build up some categories:

0-5 <5

6-10 <10

11-14 <15

and so on;

and loaded it via script into Qlik View. Then I added these categories as a second dimension. But Qlik View doesn’t group the values. See:

The problem is I think to get a connection between the values (received through the formula “count”) and the categories!?? How can I tell it that values up to 5 are shown only as category “<5”??

Von: Dennis Hoogenboom

Gesendet: Montag, 16. Mai 2011 18:42

An: Voigt, Martina__DE

Betreff: - Re: categories on dimension axe

QlikCommunity<http://community.qlik.com/index.jspa>

Re: categories on dimension axe

created by Dennis Hoogenboom<http://community.qlik.com/people/dennisnet> in New to QlikView - View the full discussion<http://community.qlik.com/message/116470#116470

Not applicable

categories on dimension axe

At the moment I get my data for the diagramm with the count formula Count ([name]).

Is it possible and if yes how to get the data like this: count ([name]) if <=5 as one formula and as 2nd formula count ([name]) if >5 and <= 10 and so on ??

Regards

Martina

Community Browser