6 Replies Latest reply: Apr 9, 2017 12:27 PM by Evgenii Senko RSS

    Separate Area Charts with two Expressions

    Evgenii Senko

      Hi,

       

      I have two dimensions

      1) Names

      2) Dates

       

      And two Expressions

      1) Leftover

      2) Done

       

      TableFact:

      LOAD * INLINE [

      Name, Date, Leftover, Done

      Name1, 01/01/2017, 100, 100

      Name1, 01/03/2017, 80, 80

      Name1, 01/10/2017, 50, 30

      Name1, 01/12/2017, 30, 50

      Name2, 01/18/2017, 150, 30

      Name2, 01/20/2017, 120, 40,

      Name2, 01/25/2017, 80, 0

      Name3, 01/25/2017, 200, 20

      Name3, 01/26/2017, 180, 30

      Name3, 02/03/2017, 150, 100

      Name3, 02/10/2017, 50, 20

      Name3, 02/14/2017, 30, 0

      ];


      I need two separate Areas with two expressions divided by two dimensions.

      The visualization is like in the attached qvw file (it shows how should looks each Name).


      - Each expression has to show separate area.

      For 'Leftover' first Area and second Area is for 'Done' expression(Is it possible to create in one layer?)


      - Each Name has to be in the period by dates where this Name has values.

      For example 'Name1' has values in the period from 01/01/2017 till 01/12/2017

      There should be one separate area with values in this period(01/01/2017 - 01/12/2017)

      The same for each Name.

      !Important: Not combined Area, only separate for each name.

      1.jpg

       

      Is it possible to create the same in QV according to requirements?

       

      Thanks!