Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

KPI Filter

I would like to see only 2007 sales record in the KPI Chart. How can I do it? Please help. Thank you in advance.

Below is the dataset

Purushothaman_0-1619573434398.png

 

1 Solution

Accepted Solutions
Digvijay_Singh

Use expression something like this - Sum({<Date={"=Year(Date)=2007"}>}SalesAmount)

View solution in original post

2 Replies
Digvijay_Singh

Use expression something like this - Sum({<Date={"=Year(Date)=2007"}>}SalesAmount)

Purushothaman
Partner - Creator III
Partner - Creator III
Author

Thank you 🙂