Group dimension in chart / Duration chart

[Anonymous]

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:

to this:

[jyothish8807]

Hi,

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

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

Br,

KC

[Anonymous]

Hi, thanks for reply.

1k means 1 thousand values.

[Anonymous]

0 - 1k shows the one thousand highest values.

[Anil_Babu_Samineni]

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

[Anonymous]

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.

[Anonymous]

[jyothish8807]

Hi ,

Pfa sample, hope the logic may help.

Br,

KC

[qlikviewwizard]

What is your Dimension filed in your final chart?

[Anonymous]

Dimension: [Date-Time]

[Date-Time] is linked to the value.

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