Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
satyaban
Contributor III
Contributor III

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:

projectdayssales
Af10
Af5
Bf200
Cf2
Cf4
Cf50
Df30
El10
El20
Fl50
Fl50
Gl20
Gl30
Hl20
Hl100

 

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

projectsum of sales
A15
B200
C56
D30


When Days = l

projectsum of sales
E30
F100
G50
H120

 

 

 

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.

Labels (1)
0 Replies