In the attached QVW you had helped me create a filter for change in values (Increase or Decrease). Now, how do I show the increase and decrease values in separate pivot tables? Instead of using the Change filter if I need to show a pivot table with increase values and another pivot table with decreased values how can we achieve that?
But what if my data model doesn't have Increase/Decrease field and it should be calculated as well. In this scenario how would you calculate and show Increases and Decreases in two different pivot tables separately.
Please find attached qvw and the data used.
I should be able to show the increase and decrease values in two separate pivot tables when I select two different dates from the week filter. For example when I select 6/5/2017 and 6/26/2017 there should be only increase values in the pivot table for Increase.
This works with the smaller data set when I work from my local Qlikview desktop. But when I apply this logic to the actual larger data set in the server I am also getting the rows where there is no change in the value and also the decreased ones. Since the pivot table has logic only to show Increase it shows 'increase' for the lines where the values have increased but for the lines where there is no change in the value and for decrease lines it is showing '-' Any idea what could be causing this?
I need to be able to show only the ones that have increased and the ones that have decreased in separate pivot tables.
Change your first expression to do this
If(Column(4) = 'Increase', Expression)
By doing this, you will be forcing those rows where the Column(4) (Increase/Decrease) is not increase to be null and the rows will go away.