topic Re: Trimmed dimension on lined-chart in QlikView

Trimmed dimension on lined-chart

Tue, 16 Apr 2013 07:37:39 GMT

Hi,

The chart above (taken from 'Whats New in Qv10.qvw') shows the accumulated sales accross dates.The dimmension's label is per trimmed to Month - MM-YYYY.

How is this done?!! No matter how deep i've looked i couldn't figure this out

Re: Trimmed dimension on lined-chart

Tue, 16 Apr 2013 10:10:43 GMT

ok. I figured this out (has to do with the number format of the dimension)

Now came the following challenage. I would like to show the sales per hour whereas the dimension label wil show the day of the week.

Can this be done?

Re: Trimmed dimension on lined-chart

sushil353 — Tue, 16 Apr 2013 10:30:24 GMT

if you have hours in your date field then u can eaisly do it...using Date funtion.

Date(date_field,'HH:MM')

HTH

Sushil

Re: Trimmed dimension on lined-chart

Tue, 16 Apr 2013 10:30:35 GMT

Hi,

Use this format in the Dimension

WeekDay(Dimension)

Re: Trimmed dimension on lined-chart

Tue, 16 Apr 2013 11:15:04 GMT

Stil not working. I've attached an example.

Re: Trimmed dimension on lined-chart

Tue, 16 Apr 2013 13:00:34 GMT

Hi ,

Try to have Two Dimension in the Chart .

1 . Date(date_field,'HH:MM') ( As Sushil Suggested )

2. WeekDay(Dimension)

please let me know if your Requirement is met .

Re: Trimmed dimension on lined-chart

Wed, 17 Apr 2013 10:36:55 GMT

Oh, I didn't you can have two cascading dimmension on same axis on line chart. How do you do that?