Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table calculate with hidden values

Hi,

I have a pivot table with four years.

With expression i calculate sum of "Livraisons" (deliveries).

After, i calculate the difference (delta) with the year before (last column). To do this i use below() function.

It works if i don't use filters years...

Example without filters:

Capture 1.jpg

Now i want to filter on 2014 and 2013 :

I use Below function and the result for 2013 is I have an empty value.

How can i use below with hidden lines?

Thanx for your help.

5 Replies
Gysbert_Wassenaar

The chart cannot calculate with values that are excluded from the data used in the chart. So you need to include it somehow. You can try creating a new dimension in the script that associates a year with the previous year. See this document for more information: Calculating rolling n-period totals, averages or other aggregations


talk is cheap, supply exceeds demand
Not applicable
Author

Ok,

I want to use AsOf table.

So i created the talbe and my result is :

Picture1.jpg

I don't know if my result is good...

What do you think?

Not applicable
Author

I've worked all my day about this problem.

I've created the AsOf table, but i don't understand how i can use it.

In the example (link), they do a Sum but in my case, i want to substract value so, i don't understand...

Could help me more ?

Anonymous
Not applicable
Author

Hello,

you can try with the logic in the qvw attached.

There are 2 variables: it seems to work, when you select couple of consecutive years, but pay attention for couple 2012-2013... I think in this precise case the output is not as you want...

But maybe it can help you.

Let me know!

BR

Elena

Gysbert_Wassenaar

Perhaps the attached example helps.


talk is cheap, supply exceeds demand