topic Group dimension in chart / Duration chart in QlikView https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69407#M775450 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>expression: sum(value)</P><P>Dimension: [Date-Time]</P><P></P><P>Can anybody help me to turn this chart:</P><P><IMG __jive_id="201820" alt="pic1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201820_pic1.png" style="height: 338px; width: 620px;" /></P><P>to this:</P><P><IMG __jive_id="201827" alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/201827_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69407#M775450 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>expression: sum(value)</P><P>Dimension: [Date-Time]</P><P></P><P>Can anybody help me to turn this chart:</P><P><IMG __jive_id="201820" alt="pic1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201820_pic1.png" style="height: 338px; width: 620px;" /></P><P>to this:</P><P><IMG __jive_id="201827" alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/201827_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69407#M775450 Anonymous 2020-11-25T16:16:04Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69408#M775451 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In the bottom chart what exactly 0k, 1k means ?</P><P>How should i read this chart, if the dimension is date ?</P><P></P><P>Br,</P><P>KC</P></BODY></HTML> Tue, 08 May 2018 12:21:30 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69408#M775451 jyothish8807 2018-05-08T12:21:30Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69409#M775452 <HTML><HEAD></HEAD><BODY><P>Hi, thanks for reply.</P><P>1k means 1 thousand values. </P></BODY></HTML> Tue, 08 May 2018 12:25:39 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69409#M775452 Anonymous 2018-05-08T12:25:39Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69410#M775453 <HTML><HEAD></HEAD><BODY><P>0 - 1k shows the one thousand highest values. </P></BODY></HTML> Tue, 08 May 2018 12:41:16 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69410#M775453 Anonymous 2018-05-08T12:41:16Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69411#M775454 <HTML><HEAD></HEAD><BODY><P>What your intention with X-Axis? First one you showed the date and output needed the data points. Not sure, I understood the requirement?</P></BODY></HTML> Tue, 08 May 2018 12:45:34 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69411#M775454 Anil_Babu_Samineni 2018-05-08T12:45:34Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69412#M775455 <HTML><HEAD></HEAD><BODY><P>the first chart is from qlikview. I want that to like like the chart below.</P><P></P><P>I want it to be a duration chart that show number of values like dimension, but shows every value within the chart. desc. </P></BODY></HTML> Tue, 08 May 2018 12:48:49 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69412#M775455 Anonymous 2018-05-08T12:48:49Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69413#M775456 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" height="157" src="https://community.qlik.com/legacyfs/online/201834_pastedImage_0.png" style="width: 366px; height: 157.026px;" width="366" /></P></BODY></HTML> Tue, 08 May 2018 12:55:41 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69413#M775456 Anonymous 2018-05-08T12:55:41Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69414#M775457 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Pfa sample, hope the logic may help.</P><P></P><P>Br,</P><P>KC</P></BODY></HTML> Tue, 08 May 2018 12:58:06 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69414#M775457 jyothish8807 2018-05-08T12:58:06Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69415#M775458 <HTML><HEAD></HEAD><BODY><P>What is your Dimension filed in your final chart?</P></BODY></HTML> Tue, 08 May 2018 13:00:58 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69415#M775458 qlikviewwizard 2018-05-08T13:00:58Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69416#M775459 <HTML><HEAD></HEAD><BODY><P>Dimension: [Date-Time]</P><P></P><P>[Date-Time] is linked to the value. </P><P>So each value is connected to one [date-hour]</P></BODY></HTML> Tue, 08 May 2018 13:02:09 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69416#M775459 Anonymous 2018-05-08T13:02:09Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69417#M775460 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201835_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 08 May 2018 13:08:00 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69417#M775460 Anil_Babu_Samineni 2018-05-08T13:08:00Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69418#M775461 <HTML><HEAD></HEAD><BODY><P>You can do step by 1000 and avoid the if condition in the dimension.</P></BODY></HTML> Tue, 08 May 2018 13:14:55 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69418#M775461 jyothish8807 2018-05-08T13:14:55Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69419#M775462 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe one solution could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_300616_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201883_QlikCommunity_Thread_300616_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 08 May 2018 21:43:39 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69419#M775462 MarcoWedel 2018-05-08T21:43:39Z Re: Group dimension in chart / Duration chart https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69420#M775463 <HTML><HEAD></HEAD><BODY><P>Thank you! wokrs perfect <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P></BODY></HTML> Tue, 15 May 2018 13:23:31 GMT https://community.qlik.com/t5/QlikView/Group-dimension-in-chart-Duration-chart/m-p/69420#M775463 Anonymous 2018-05-15T13:23:31Z