I want to export a qlikview object (table box) to an excel sheet and then split it into multiple sheets based on the first column of the table box. My table would be something like below. I would want to export ID with value 1 in Sheet1, ID-2 in sheet2 etc.
Any suggestions? Thanks in advance.
ID | average | count |
1 | 900 | 100 |
1 | 901 | 101 |
1 | 902 | 102 |
1 | 903 | 103 |
2 | 904 | 104 |
2 | 905 | 105 |
2 | 906 | 106 |
2 | 907 | 107 |
3 | 908 | 108 |
3 | 909 | 109 |
3 | 910 | 110 |
3 | 911 | 111 |