13 Replies Latest reply: Dec 3, 2014 12:26 AM by Ravi Taneja RSS

    Creating a Line chart which shows peak values from a column for each month?

      Hi Qlik users

       

      Can anyone help me with this requirement please?

       

      I have a source data which is attached in a excel sheet. Requirement is to plot a line graph on monthly basis plotting peak value of throughput on each link 1 and link 2. Source data has a weekly and daily break down too for example:

       

      DateWeekLink1Link2TotalYearMonth
      7/04/20131514,100,89214,310,19928,411,09120134
      8/04/20131515,209,6658,597,18523,806,85020134
      9/04/20131516,235,04511,249,54827,484,59220134
      10/04/20131514,901,23512,821,36427,722,59820134
      11/04/20131516,558,74310,496,90127,055,64420134
      12/04/20131513,278,0239,572,06022,850,08320134
      13/04/20131515,591,7208,713,67524,305,39520134
      14/04/20131613,373,0359,142,06422,515,09920134
      15/04/20131616,079,63210,944,45627,024,08820134
      16/04/20131616,049,9438,821,56924,871,51220134
      17/04/20131617,754,93511,346,52229,101,45720134
      18/04/20131619,439,13510,302,64029,741,77620134
      19/04/20131616,326,61911,336,96027,663,57920134
      20/04/20131619,197,95210,116,81429,314,76620134
      21/04/20131714,186,1049,557,83223,743,93620134
      22/04/20131713,635,80510,439,44124,075,24520134
      23/04/20131712,957,84912,983,06825,940,91720134
      24/04/20131710,111,0229,595,16819,706,19020134
      25/04/20131711,903,72912,835,19024,738,91920134
      26/04/20131711,850,43910,303,61722,154,05620134
      27/04/2013179,968,3358,513,60418,481,93920134
      28/04/20131810,459,08010,075,96120,535,04120134
      29/04/2013189,557,3298,201,04317,758,37220134
      30/04/20131810,263,6158,653,94618,917,56120134
      1/05/2013188,738,2168,114,80816,853,02420135
      2/05/20131812,947,4119,014,87121,962,28220135
      3/05/2013188,864,1298,481,55617,345,68620135
      4/05/2013188,864,1298,481,55617,345,68620135
      5/05/20131914,766,32810,003,38824,259,12420135
      6/05/20131912,752,65014,482,70823,887,86620135
      7/05/20131911,635,01913,997,36722,604,91420135
      8/05/20131912,868,80513,224,40923,622,16020135
      9/05/20131913,664,72913,870,30024,196,22920135
      10/05/20131914,578,74911,696,60822,411,80720135

       

      So on the graph on the x axis i want Month (but not as a number but as text Jan feb etc), so for example looking for the month February i.e Month 2, the peak value should be shown  for link 1 and link 2 on two separate lines from the months of feb (feb will have entries from week 5 till 9)

       

      On y axis i want throughput but in Mbps (data source has it in bits for example 14,578,749 bits which on the graph should be converted into Mbits using formula by dividing by 1048576 as 1Mbits = 1048576bits hence 14,578,749/1,048,576 = 13.9 Mbits)

       

      Once monthly graph is ready i'd like to drill down to Weekly peaks followed by daily.

       

      Many thanks in advance for any help i could get.