Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add more than 2 dimensions Qlik Sense

Dear all,

Could someone tell me if it's possible to add more than 2 dimensions for bar chart?

e.g. Holiday week(Week of Thanksgiving holiday), Date (dd/mm/yyyy) and Weekday(Mon, Tue etc).

I can only add Holiday week and Date and then the dimensions button is greyed out.

Ideally this could be done as it's most flexible for future use.

If not, then can Qlik sense convert date to weekday by some sort of formula?

Capture.PNG

Thanks!

1 Solution

Accepted Solutions
isaaclin
Contributor III
Contributor III

I think you need add a field in your table as weekday in data load editor

under your load statement

Weekday(date) as WeekDay

then you have weekday as a field when you building expression.

I dont think bar chart supports more than 2 dimensions

check this Bar chart ‒ Qlik Sense

View solution in original post

2 Replies
isaaclin
Contributor III
Contributor III

I think you need add a field in your table as weekday in data load editor

under your load statement

Weekday(date) as WeekDay

then you have weekday as a field when you building expression.

I dont think bar chart supports more than 2 dimensions

check this Bar chart ‒ Qlik Sense

Not applicable
Author

Thanks Issac, The bar chart link is useful. Not too familiar with data load editor yet but I'll play around.