Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
New Contributor III

Re: How to add more than 2 dimensions Qlik Sense

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

2 Replies
isaaclin
New Contributor III

Re: How to add more than 2 dimensions Qlik Sense

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

Re: How to add more than 2 dimensions Qlik Sense

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

Community Browser