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.