Dimension has same values but the value of the expression is different
i have one question:
I want that the time 50 shuld be shown. I know that QlikView don't know which Value should be shown becuase the time is the same. Can i use the above-function? If the Time is the same, i want the first value, in this case Value 80 should be shown at time 50.
Re: Dimension has same values but the value of the expression is different
The problem is that you do not use an aggregation function. The expression is always an aggregation and if you don't specify which one to use, QlikView will use the Only() function. Which in this case returns NULL, since you have more than one possible value for this time.
Change to Sum(Value) or Avg(Value) and it will work.