Dear All,
I have a complex requirements as below which is difficult for me to find out solution .Kindly help me for same.
Lets say I have data set as below:
| project | days | sales |
| A | f | 10 |
| A | f | 5 |
| B | f | 200 |
| C | f | 2 |
| C | f | 4 |
| C | f | 50 |
| D | f | 30 |
| E | l | 10 |
| E | l | 20 |
| F | l | 50 |
| F | l | 50 |
| G | l | 20 |
| G | l | 30 |
| H | l | 20 |
| H | l | 100 |
Now I have to show top 2 Projects in table chart based on sum of sales values from each Days category(f or l) i.e 4 rows in table chart first 2 rows from when Days =f and second two rows when Days = l
Example :
When Days = f
| project | sum of sales |
| A | 15 |
| B | 200 |
| C | 56 |
| D | 30 |
When Days = l
| project | sum of sales |
| E | 30 |
| F | 100 |
| G | 50 |
| H | 120 |
Now in Table chart first row should be B , second row --C then third row --H and fourth Row ---F
This is my requirement kindly suggest how to achieve using scripts in Qlik sense Table Chart.
