Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Chart Inter Record return excluding combination/value

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

Re: Chart Inter Record return excluding combination/value

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

Re: Chart Inter Record return excluding combination/value

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

Not applicable

Re: Chart Inter Record return excluding combination/value

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

Re: Chart Inter Record return excluding combination/value

Any solution?

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

sunilkumarqv
Valued Contributor II

Re: Chart Inter Record return excluding combination/value

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

Not applicable

Re: Chart Inter Record return excluding combination/value

for test = C,

=Before(Exp1) is returning 2000

whereas =Exp1 would return 1500

sunilkumarqv
Valued Contributor II

Re: Chart Inter Record return excluding combination/value

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

Re: Chart Inter Record return excluding combination/value

This is my target:

AAAA.png

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

Community Browser