Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a question regarding straight tables in Qlikview and how expressions act within them. I have a straight table that has a expression column which references two preceding dimension columns. Everything works fine at this point. However, I need to add two additional dimension columns to the table as identifying information. When I add the two additional dimensions, the expression column changes in value and I can't figure out why. In my expression formula, I reference the columns by their labels and not their index number so I am not sure why this would confuse Qlikview.
Here is the expression I'm using if it helps:
=If([Netsetid]<>Above([Netsetid],1,RowNo()),
[Gross Exposure],
If(Above([Running Net Long Exposure],1,RowNo())<0 and [Gross Exposure]>0,
If(Maturity_Bucket<>Above(Maturity_Bucket,1,RowNo()),
[Gross Exposure],
Above([Running Net Long Exposure],1,RowNo())+[Gross Exposure]
),
Above([Running Net Long Exposure],1,RowNo())+[Gross Exposure]
)
)
An example of my problem: The expression will display the [Gross Exposure] even when I can see that [Netsetid]=Above([Netsetid],1,RowNo()). This only happens when I have added the additional dimension columns. Any help would be appreciated, thanks!
Would you be able to share a sample to look at the issue? Difficult to say much by just looking at the expression and not knowing the data behind it