Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

before

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?

ReferencePhase
125457Z03
125457Z05
199125Z02
199125Z02
301547Z01
455124Z01

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

Tags (1)
2 Replies
upaliwije
Contributor II

Re: before

Not Working

Not applicable

Re: before

Hi,

Check my app.

Community Browser