4 Replies Latest reply: Jun 30, 2017 1:01 PM by Neelima Alapati RSS

    Report Format Layout

    Neelima Alapati

      I am new to Qliksense and need some advice in report format layout.

       

      I have a table with category as dimension(catgery1,catgery2,catgery3...), and my measures are the

      count(column ) for current year,

      counts(column ) prevous year,

      counts(column ) previous 2 year,

      difference in counts # between current year and (column 2) previous year

      difference in counts #  between previous year and previous 2 year

      differecne in counts # between previous 2Yr-previous 3YR

      difference in % between current year and (column 2) previous year

      difference in % between previous year and previous 2 year

      differecne in % between previous 2Yr-previous 3YR

      Total fees for current year,

      Total fees previous year,

      Total fees previous 2 year,

      difference inTotal fees between current year and (column 2) previous year

      difference in Total fees  between previous year and previous 2 year

      difference in Total fees between previous 2Yr-previous 3YR

      difference in Total fees % between current year and (column 2) previous year

      difference in Total fees % between previous year and previous 2 year

      difference in Total fees % between previous 2Yr-previous 3YR

       

       

      I have a filter pane in my report, with Year column . For whatever year picked by user, my counts and Difference # and difference % should change accordingly. And they are chaging accordngly. But my report layout is turning into a wide report with alll the measure coming in a very long row for each category...

       

      But instead i want something like the one i depicted in excel..please take a look at the attahed Excel sheet for reference. ....From a wide table ..i need to change it into a narrow table..can anyone help me in this

       

      Thanks a lot,

      Neelima