Top 10 in straight table Qliksense

[Anonymous]

Hi All,

Requirement is to restrict the last 10 customers based on issueddate. Need to restrict the customer data based on dates for the below table. I'm not able to restrict it in Qliksense. Kindly let me know how to proceed:

Dimensions are :

Customer ID

Customer Name

IssuedDate

Expression:

Premium

Customer ID	Customer Name	IssuedDate	Premium
1	ABC	8/8/2018	100
2	EFG	8/9/2018	200
3	CFG	8/10/2018	300
4	ADF	8/11/2018	3576
5	JAF	8/12/2018	2890
6	QSD	8/13/2018	2647
7	ABC	8/14/2018	4557
8	ERT	8/15/2018	9089
9	WSC	8/16/2018	784
10	SDF	8/17/2018	3546
11	ABC	8/18/2018	1678
12	QSD	8/22/2018	1678
13	QWR	8/22/2018	345
14	RDF	8/22/2018	574
15	GHH	8/22/2018	678

Expected result from QS is to show only this 10 customers

Customer ID	Customer Name	IssuedDate	Premium
12	QSD	8/22/2018	1678
13	QWR	8/22/2018	345
14	RDF	8/22/2018	574
15	GHH	8/22/2018	678
11	ABC	8/18/2018	1678
10	SDF	8/17/2018	3546
9	WSC	8/16/2018	784
8	ERT	8/15/2018	9089
7	ABC	8/14/2018	4557
6	QSD	8/13/2018	2647

Thanks in advance,

Anupama Jagan

[Anonymous]

should I do it for all dimension?

[agigliotti]

did you check the qvw document I sent ?

[Anonymous]

yes Andrea, but I'm not able to get any value in QS application

[agigliotti]

could you share your qvf file ?

[Anonymous]

sorry I work in client environment and will not able to share the files. will all qv functions work in qs as same? just not able to understand why no data is being populated

[agigliotti]

yes I used your data therefore it should works as well as in QlikView.

could you attach a printscreen of your sense table ?