Dimension has same values but the value of the expression is different

[#1]

Hello Community,

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.

The example is attached.

thank you for your help!

Best regards,

Aylin

[hic]

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.

Read more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/08/03/the-only-function

HIC

[hic · Accepted solution]

... or if you want the first string (or rather, the smallest) you should use Minstring() or Min().

HIC

[#4]

Thank you very much Henric! I used the max-function.