How to show top N values in table charts for different categories ?
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
Table Chart Project
B
C
H
F
This is my requirement kindly suggest how to achieve using scripts in Qlik sense Table Chart.