topic Bar chart without using filtering fields? in QlikView

Bar chart without using filtering fields?

Tue, 10 Aug 2010 12:00:14 GMT

I would like to make a bar chart out of 2 fields, Age and Categori
Age is a field consising af ages from 1 to70 and Categori consists of A;B;C;D and E.

I want to make Age catogories as well, som the Bar chart shows how many Ages of ex. 15,16 and 17 there are ind Categori A and B and C and so on.

I have tried using IF i a calculated dimension and also and expression - but cant make it work.

Bar chart without using filtering fields?

Tue, 10 Aug 2010 12:07:35 GMT

Hi,

Plz clarify your query:

"....som the Bar chart shows how many Ages of ex. 15,16 and 17 there are ind Categori A and B and C and so on...."

Not understood.

Bar chart without using filtering fields?

Tue, 10 Aug 2010 12:23:33 GMT

there was a small typing error, sorry.

What I want to show in the bar chart is howmany with the age 15,16 and 17 are in categori a and how many in B and so on

Bar chart without using filtering fields?

Tue, 10 Aug 2010 12:40:56 GMT

Mayby an expression something like this

count(if(age = 15,16,17 age)) but this doesnt work

Bar chart without using filtering fields?

Tue, 10 Aug 2010 12:45:14 GMT

I think I got it myself using this

count(if(age> 14 and age < 18, age))

Bar chart without using filtering fields?

Wed, 11 Aug 2010 07:55:52 GMT

Hi,

Plz refer to the attachment.

Create a pivot chart having dimensions as Age, Category and

expression as Count(Category).

You will get the answer.

Happy Thoughts

Bar chart without using filtering fields?

Wed, 11 Aug 2010 07:58:50 GMT

Hi,

Attachment is here.