Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
... or if you want the first string (or rather, the smallest) you should use Minstring() or Min().
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
... or if you want the first string (or rather, the smallest) you should use Minstring() or Min().
HIC
Thank you very much Henric! I used the max-function.