Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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
Contributor III

Re: Dimensions NOT aggregate

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

5 Replies
MVP
MVP

Re: Dimensions NOT aggregate

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;

MVP
MVP

Re: Dimensions NOT aggregate

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),

Re: Dimensions NOT aggregate

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

Re: Dimensions NOT aggregate

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

veidlburkhard
Contributor III

Re: Dimensions NOT aggregate

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