topic Re: Dimensions NOT aggregate in QlikView

Dimensions NOT aggregate

Sun, 20 Mar 2016 11:42:06 GMT

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:

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

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

Thanks!

Re: Dimensions NOT aggregate

maxgro — Sun, 20 Mar 2016 11:56:56 GMT

Dimensions

- Week

- WeekDay

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;

Re: Dimensions NOT aggregate

swuehl — Sun, 20 Mar 2016 11:57:41 GMT

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

rubenmarin — Sun, 20 Mar 2016 11:58:15 GMT

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.

Re: Dimensions NOT aggregate

Sun, 20 Mar 2016 12:35:05 GMT

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

Re: Dimensions NOT aggregate

veidlburkhard — Sun, 20 Mar 2016 14:55:06 GMT

Hi SaCvP125,

please go through these 3 steps:

i) Change your script like this:

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:

First Week then Weekday.

iii) Enter these two expressions and see the result:

Hope this helps

Burkhard