topic Distinct dimension in grid chart in QlikView

Distinct dimension in grid chart

matteogm — Tue, 10 Dec 2013 10:13:13 GMT

Hi everybody,

if I have a data table like this:

DAY, HOUR, VALUES
01/01/2013, 07:00, 12

01/01/2013, 07:30, 18

01/01/2013, 08:00, 115

01/01/2013, 08:30, 82

01/01/2013, 09:00, 91

....

02/01/2013, 07:00, 27

02/01/2013, 07:30, 79

02/01/2013, 08:00, 87

02/01/2013, 08:30, 12

How can I create a grid chart with DAY and HOUR dimensions, with every distinct DAY displayed only once and not repeated??

I can not aggregate the distinct values on the chart.

Should be a basic question.

Thanks in advance.

Matteo

Nicole-Smith — Wed, 11 Dec 2013 19:00:57 GMT

If your data matches the example data in your post, it should automatically group them (see attached).

I'm guessing your data isn't the same as your example and that you have a datetime instead of just a date. Try changing your dimension to:

daystart(DAY)

which should cause all the datetimes for that day to be the same.

matteogm — Thu, 12 Dec 2013 08:09:26 GMT

Thanks Nicole,

actually data come from an excel sheet, DAY is displayed as in the example (format DD/MM/YYYY).

Even if I add in the script date# function, days are not grouped. (date#(DAY,'DD/MM/YYYY')).

daystart(DAY) in dimension solves the problem!

Thanks.

Matteo