topic Re: Change in Sales Pivot in QlikView

Change in Sales Pivot

Wed, 19 Jul 2017 15:25:20 GMT

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?

Re: Change in Sales Pivot

Anil_Babu_Samineni — Wed, 19 Jul 2017 16:08:05 GMT

Like this?

Re: Change in Sales Pivot

sunny_talwar — Wed, 19 Jul 2017 16:19:15 GMT

May be like this

Re: Change in Sales Pivot

Wed, 19 Jul 2017 18:17:31 GMT

Thank you for the response stalwar1‌ and loveisfail‌
I am looking for an output as shown by Sunny where I can show Increases and Decreases in separate Pivot Tables.

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.

Re: Change in Sales Pivot

sunny_talwar — Wed, 19 Jul 2017 18:59:14 GMT

I was not referring to the field name, but to the expression label. The expression still works...

Re: Change in Sales Pivot

Wed, 19 Jul 2017 19:49:18 GMT

Thanks stalwar1‌

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.

Re: Change in Sales Pivot

sunny_talwar — Wed, 19 Jul 2017 19:50:24 GMT

Can you show an image of what you are seeing?

Re: Change in Sales Pivot

Wed, 19 Jul 2017 20:16:08 GMT

This is how it looks like. Need to get rid of rows with '-' and only show the rows where values has increased.

Re: Change in Sales Pivot

sunny_talwar — Wed, 19 Jul 2017 23:08:54 GMT

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.

Re: Change in Sales Pivot

Thu, 20 Jul 2017 14:45:44 GMT

If I do that then I get like below. The first expression values show as '-' but still pivot table shows those lines.

Re: Change in Sales Pivot

sunny_talwar — Thu, 20 Jul 2017 15:05:48 GMT

On the presentation tab select 'Suppress Zero Value'

Re: Change in Sales Pivot

Thu, 20 Jul 2017 15:15:00 GMT

I am currently selecting 'Suppress Zero Value' but still it's giving those lines with '-' values.

Re: Change in Sales Pivot

sunny_talwar — Thu, 20 Jul 2017 15:17:30 GMT

Do you have may be another expression? Not sure, I would have to take a look at it...