Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar chart without using filtering fields?

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.

6 Replies
Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

Mayby an expression something like this

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

Not applicable
Author

I think I got it myself using this

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

Not applicable
Author

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

Not applicable
Author

Hi,

Attachment is here.