topic Re: Delta with three dimensions in table? in QlikView

Delta with three dimensions in table?

Tue, 20 May 2014 18:28:27 GMT

Hi,

I have a problem to do a delta with three dimensions. With two dimensions, using Secondary Dimensionality is fine, but with three dimensions doesn't work.

Can someone help me?

Follow attached an example.

Thanks!

Re: Delta with three dimensions in table?

swuehl — Tue, 20 May 2014 19:09:05 GMT

Guilherme, could you check your attachment? Can't see neither the data nor the table chart.

Re: Re: Delta with three dimensions in table?

Tue, 20 May 2014 19:21:00 GMT

Sorry swuehl. I think it's easier an excel file, I don't know why the qv file doesn't works.

Re: Delta with three dimensions in table?

swuehl — Tue, 20 May 2014 19:23:35 GMT

How does your expression look like?

Re: Delta with three dimensions in table?

Tue, 20 May 2014 19:25:58 GMT

if(SecondaryDimensionality()=0, last(sum(Sales))-first(sum(Sales)), sum(Sales))

Re: Delta with three dimensions in table?

swuehl — Tue, 20 May 2014 19:31:07 GMT

You probably need to test SecondaryDimensionality() against 1, not 0.

Just input an expression

=SecondaryDimensionality()

and see what is returned at that column.

Re: Delta with three dimensions in table?

Wed, 21 May 2014 12:18:59 GMT

You're right swuehl, thanks!