Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dimensions NOT aggregate

Hello,

I've this application in attach. I'm trying to build a chart that shows all the days per week. When I'm trying to create it, I obtain this chart:

Capture.PNG
But I want to tho show all day weeks by Week. Someting like this:

Capture1.PNG

Basically, I want to show all the days from the weeks in chart.

Thanks!

1 Solution

Accepted Solutions
veidlburkhard
Creator III
Creator III

Hi SaCvP125,

please go through these 3 steps:

i) Change your script like this:

GoalsperWeekday3.jpg

Take care of the date format and add the date field in the second table also.

ii) In the user interface add a bar chart with these dimensions:

GoalsperWeekday2.jpg

First Week then Weekday.

iii) Enter these two expressions and see the result:

GoalsperWeekday.jpg

Hope this helps

Burkhard

View solution in original post

5 Replies
maxgro
MVP
MVP

Dimensions

- Week

- WeekDay

1.png

SET DateFormat='DD/MM/YYYY';

Table:

LOAD * INLINE

[

Team,Num_Goals, Date

A,3,29/02/16

B,2,01/03/16

C,5,02/03/16

D,2,03/03/16

E,7,04/03/16

A,3,07/03/16

B,2,08/03/16

C,5,09/03/16

D,2,10/03/16

E,7,11/03/16

A,3,14/03/16

B,2,15/03/16

C,5,16/03/16

D,2,17/03/16

E,7,18/03/16

];

LOAD

Date,

WeekDay(Date) as WeekDay,

Day(Date) as Day,

Dual('Week ' & wEEK(Date), wEEK(Date)) as Week,

Month(Date) as Month,

Year(Date) as Year

Resident Table;

swuehl
MVP
MVP

Looks like you just need to change the order of dimensions.

See attached (needed to recreate most, because your sample showed empty sheets and unlinked tables),

rubenmarin

Hi, some things to comment:

- Your DateFormat variable has different from than the one you have in your inline table, so you need to use Date#() to tell QV the dateformat he is reading.

- You need to link both tables so I added the Date field to the 2nd table, just with that both tables are linked by date

- Not absolutely needed, but I renamed some fields of the 2nd table

- I also added the 'Week' string to the week field, using Dual() to keep the numeric value

With this I created a chart by week and an expression for each day using set analisys, PFA

Edit: as swhuel said, it's easier just switching dimensions, I updated the attachment.

Not applicable
Author

Thank you but what I want to show in chart is the day of the week repeatedly:

veidlburkhard
Creator III
Creator III

Hi SaCvP125,

please go through these 3 steps:

i) Change your script like this:

GoalsperWeekday3.jpg

Take care of the date format and add the date field in the second table also.

ii) In the user interface add a bar chart with these dimensions:

GoalsperWeekday2.jpg

First Week then Weekday.

iii) Enter these two expressions and see the result:

GoalsperWeekday.jpg

Hope this helps

Burkhard