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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 🙂