before

Wed, 27 Feb 2013 12:05:42 GMT

Dear all,

i have a pivottbale and i want to use this as dimension but it does not seem to work.

Anybody that can help me out how to correct this?

Reference	Phase
125457	Z03
125457	Z05
199125	Z02
199125	Z02
301547	Z01
455124	Z01

Reference is sorted and is a dimension in my pivot table

Now i want to highlight or only show the lines with following criteria

reference=above(reference) and phase<>above(phase)

At the moment i tried

=if([3rdPartyRef]=before([3rdPartyRef]),
           if([3rdPartyName]<>before([3rdPartyName]),
                1,
                null()
          )
)

But this gives me //error in calculation

Re: before

upaliwije — Sat, 21 Jun 2014 12:20:05 GMT

Not Working

Re: before

Sat, 21 Jun 2014 17:52:07 GMT

Hi,

Check my app.

topic before in QlikView

before

Re: before

Re: before