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

Chart Inter Record return excluding combination/value

When using before,first,above,... it returns combination which are usually hidden

ScreenHunter_38 Mar. 03 16.52.jpg

First pivot with a simple expression =SUM(AAA)

ScreenHunter_39 Mar. 03 16.52.jpg

Then adding a 2nd expression =Before(Exp1)

A.png

Why do I get these extra column/row? Any solution?

9 Replies
Not applicable
Author

Hi Nicolas

Before()/After() returns null for all objects except pivot tables. In pivot table it works like Below()/Above() in other charts.

In addition to this Above() by default returns null in first row and Below() returns null on the last row (no row exists before first row and no row exists after last row)

Lukasz

Not applicable
Author

Hi Lukasz,

I am not sure to understand completely. I am using a pivot. In my example, why are the first row and first column showing? There is no related data with the expression sum(AAA)

What is the solution?

Not applicable
Author

Before in Column A is null because there is no column before A. A is the first column.

Not applicable
Author

I do not get you. May be my example is not clear. Can you open the attached qvw?

In the first pivot, column where Test=A is not showing as there  is no record matching with the expression =SUM(AAA)

Now, why after adding a 2nd expression = Before(Exp1), this column get displayed? Same goes for the first row.

How do I keep this hidden? Do I need any set analysis with the Before expression? Is Set Analysis compatible with Before/Above/...?

Not applicable
Author

Any solution?

Is there a tweak with Set Analysis or If condition, without any performance impact?

sunilkumarqv
Specialist II
Specialist II

I dont understand why you using  =Before(Exp1) instead of that simply change the =(Exp1)  and what you want to achieve?

Not applicable
Author

for test = C,

=Before(Exp1) is returning 2000

whereas =Exp1 would return 1500

sunilkumarqv
Specialist II
Specialist II

Thats wright such  manner

test = B returning Null Because A = null

test = A before no column so returning  A = null

My  Question is  what you want to understand from that ?and what you want to achieve O/P ie o/p?

Not applicable
Author

This is my target:

AAAA.png

This is just an example, later I want enhance Expression 2 to compute % growth..