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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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 🙂