Straight Table expressions referencing unknown data

Wed, 31 Aug 2016 18:28:04 GMT

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!

Re: Straight Table expressions referencing unknown data

sunny_talwar — Wed, 31 Aug 2016 18:42:02 GMT

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

topic Re: Straight Table expressions referencing unknown data in QlikView

Straight Table expressions referencing unknown data

Re: Straight Table expressions referencing unknown data