Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

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

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

1 Solution

Accepted Solutions
Highlighted

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

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

HIC

View solution in original post

3 Replies
Highlighted

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.

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

HIC

Image1.png

Highlighted

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

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

HIC

View solution in original post

Highlighted
Not applicable

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

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