topic Re: Chart Inter Record return excluding combination/value in QlikView

Chart Inter Record return excluding combination/value

Mon, 03 Mar 2014 08:57:13 GMT

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

First pivot with a simple expression =SUM(AAA)

Then adding a 2nd expression =Before(Exp1)

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

Re: Chart Inter Record return excluding combination/value

Mon, 03 Mar 2014 09:03:02 GMT

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

Re: Chart Inter Record return excluding combination/value

Mon, 03 Mar 2014 09:13:13 GMT

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?

Re: Chart Inter Record return excluding combination/value

Mon, 03 Mar 2014 09:16:35 GMT

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

Re: Chart Inter Record return excluding combination/value

Mon, 03 Mar 2014 09:46:57 GMT

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/...?

Re: Chart Inter Record return excluding combination/value

Tue, 04 Mar 2014 05:34:27 GMT

Any solution?

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

Re: Chart Inter Record return excluding combination/value

sunilkumarqv — Tue, 04 Mar 2014 06:50:36 GMT

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

Re: Chart Inter Record return excluding combination/value

Tue, 04 Mar 2014 07:10:19 GMT

for test = C,

=Before(Exp1) is returning 2000

whereas =Exp1 would return 1500

Re: Chart Inter Record return excluding combination/value

sunilkumarqv — Tue, 04 Mar 2014 07:40:16 GMT

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?

Re: Chart Inter Record return excluding combination/value

Tue, 04 Mar 2014 08:16:15 GMT

This is my target:

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