Discussion board where members can get started with QlikView.
I am looking for an expression that will limit the results of a pivot table to customers that have not ordered anything in the past 3 years.
I have tired making the dimension: If(max(Yearord)<=Year(Today())-3,name) but this is not working.
Go to Solution.
What I meant was to list out the customers and their last order year. Just to confirm if there are any such.
So from the data only b has not placed orders in the last 3 years. You can try the following:
Can you create a table with name and Max(Yearord), just to check if there are any records.
I am not sure what you mean.
When I create a list box that has the name as the dimension with an added expression for max(Yearord) it displays fine. There are a few customers that have no returned value.
name years ordered
With the above example, I would like to only see:
This works. Thank you Kiran.