Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
GB41
Contributor
Contributor

Filtering data in a chart/kpi

I am fairly new to Qlik and have been looking at creating a dashboard for the purchasing team. 

 

One of their requirements is to have the value of all purchased items on overdue PO lines. 

We have the fields

PartID for the items

LineTotal for the Value

OverdueFlag to mark the overdue status. 

 

I have created the chart which shows me the total line value per part I am just not sure how to filter this data so its only showing values from orders marked overdue. 

 

 

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Assuming your calculation for total line per part is sum(LineTotal), and that the OverdueFlag holds the value 'True' when overdue,  then the syntax for filtering on OverdueFlag is sum({<OverdueFlag={'True'}>}LineTotal) 

View solution in original post

1 Reply
Vegar
MVP
MVP

Assuming your calculation for total line per part is sum(LineTotal), and that the OverdueFlag holds the value 'True' when overdue,  then the syntax for filtering on OverdueFlag is sum({<OverdueFlag={'True'}>}LineTotal)