Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Contributor II

Group dimension in chart / Duration chart

Hi,

I have around 8 760 values within a year, i need to group it from max value - low value by thousands like in the chart below.

expression: sum(value)

Dimension: [Date-Time]

Can anybody help me to turn this chart:

pic1.png

to this:

1 Solution

Accepted Solutions
Highlighted

Re: Group dimension in chart / Duration chart

Hi,

maybe one solution could be:

QlikCommunity_Thread_300616_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

13 Replies
Highlighted
Honored Contributor II

Re: Group dimension in chart / Duration chart

Hi,

In the bottom chart what exactly 0k, 1k means ?

How should i read this chart, if the dimension is date ?

Br,

KC

Best Regards,
KC
Highlighted
Contributor II

Re: Group dimension in chart / Duration chart

Hi, thanks for reply.

1k means 1 thousand values.

Highlighted
Contributor II

Re: Group dimension in chart / Duration chart

0 - 1k shows the one thousand highest values.

Highlighted

Re: Group dimension in chart / Duration chart

What your intention with X-Axis? First one you showed the date and output needed the data points. Not sure, I understood the requirement?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II

Re: Group dimension in chart / Duration chart

the first chart is from qlikview. I want that to like like the chart below.

I want it to be a duration chart that show number of values like dimension, but shows every value within the chart. desc.

Highlighted
Contributor II

Re: Group dimension in chart / Duration chart

Highlighted
Honored Contributor II

Re: Group dimension in chart / Duration chart

Hi ,

Pfa sample, hope the logic may help.

Br,

KC

Best Regards,
KC
Highlighted
Honored Contributor II

Re: Group dimension in chart / Duration chart

What is your Dimension filed in your final chart?

Highlighted
Contributor II

Re: Group dimension in chart / Duration chart

Dimension: [Date-Time]

[Date-Time] is linked to the value.

So each value is connected to one [date-hour]