Discussion Board for collaboration on QlikView Scripting.
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 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
Check my app.