Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
anupamajagan
Creator
Creator

Top 10 in straight table Qliksense

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 IDCustomer NameIssuedDatePremium
1ABC8/8/2018100
2EFG8/9/2018200
3CFG8/10/2018300
4ADF8/11/20183576
5JAF8/12/20182890
6QSD8/13/20182647
7ABC8/14/20184557
8ERT8/15/20189089
9WSC8/16/2018784
10SDF8/17/20183546
11ABC8/18/20181678
12QSD8/22/20181678
13QWR8/22/2018345
14RDF8/22/2018574
15GHH8/22/2018678

Expected result from QS is to show only this 10 customers

   

Customer IDCustomer NameIssuedDatePremium
12QSD8/22/20181678
13QWR8/22/2018345
14RDF8/22/2018574
15GHH8/22/2018678
11ABC8/18/20181678
10SDF8/17/20183546
9WSC8/16/2018784
8ERT8/15/20189089
7ABC8/14/20184557
6QSD8/13/20182647

Thanks in advance,

Anupama Jagan

15 Replies
anupamajagan
Creator
Creator
Author

should I do it for all dimension?

agigliotti
Partner - Master III
Partner - Master III

did you check the qvw document I sent ?

anupamajagan
Creator
Creator
Author

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

agigliotti
Partner - Master III
Partner - Master III

could you share your qvf file ?

anupamajagan
Creator
Creator
Author

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
Partner - Master III
Partner - Master III

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

could you attach a printscreen of your sense table ?