quick question regarding first sorted value

[#1]

Hi Guys,

I have a text object with the following code:

='Division with the highest expenses :'  &  firstsortedvalue(Division,-aggr(sum(expenses),Division))

I would like to display the division name that has the highest expenses. There must be something wrong with my expression.

Hope some one can help.

Cheers

Carter!

[#2]

HI,

Deepak: thanku for giving me confidence....

Plaease explain Datamodel...

[#3]

Hi ,

Please any one can Explain.....

Which Schema supports in Qlikview and Why? (Star Schema and SnowFlake Schema)

What is Optimization load ?