Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

soniyan1
New Contributor

Vintage Analysis

Hi All,

Please find attached data

I have Table1 like this and need to arrange like Table 2.Can somebody let me know what is the workaround i.e using in set analysis to get output like Table 2

Table 1 :

Row LabelsSum of Aug 2016Sum of Sep 2016Sum of Oct 2016Sum of Nov 2016Sum of Dec 2016Sum of Jan 2017Sum of Feb 2017
Jul 201639351494276720321510
Aug 20162121194254720011469
Sep 20169784184917121258
Oct 2016392194919901460
Nov 2016173496266
Dec 2016212
Jan 201722
Feb 2017
Mar 2017

         

Row LabelsMOB1MOB2MOB3MOB4MOB5MOB6MOB7MOB8
Jul 2016 3 9 35 1,494 2,767 2,032 1,510 1,185
Aug 2016 2 12 1,194 2,547 2,001 1,469 1,102 1,274
Sep 2016 9 784 1,849 1,712 1,258 924 1,008 938
Oct 2016 392 1,949 1,990 1,460 1,060 1,099 1,032 1,043
Nov 2016 173 496 266 203 191 205 195 155
Dec 2016 2 12 6 16 20 11 20 32
Jan 2017 22 66 130 165 154 117 128 -  
Feb 2017 37 80 79 90 83 105 -   -  
Mar 2017 21 60 69 91 102 -   -   -  
Community Browser