Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
MarcoWedel

Hi,

maybe one solution could be:

QlikCommunity_Thread_300616_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

13 Replies
jyothish8807
Master II
Master II

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
Anonymous
Not applicable
Author

Hi, thanks for reply.

1k means 1 thousand values.

Anonymous
Not applicable
Author

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?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable
Author

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
Not applicable
Author

jyothish8807
Master II
Master II

Hi ,

Pfa sample, hope the logic may help.

Br,

KC

Best Regards,
KC
qlikviewwizard
Master II
Master II

What is your Dimension filed in your final chart?

Anonymous
Not applicable
Author

Dimension: [Date-Time]

[Date-Time] is linked to the value.

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