Discussion Board for collaboration on QlikView Layout & Visualizations.
Does someone know how to calculate a Min expression in a chart with two dimensions?
The idea is recreate the next chart but using two dimensions (the second dimension returns me the correct number of blue dots)
The blue line that we see is a MAX line.
The expression for it is: If ( Rank(Sum(PROD)) = 1, Sum(PROD))
But for the min line I can have a rank between 2 and 4. So I use the Rank = 2 or Rank >= 2 because I will get more than one min value.
The expressions used are:
I hope someone can help me.
The sugestions present in the forum can't help me, because I need to be able to select values in lines and dots. So having two charts ( one on the top of each other) is not an option.
If ( Rank( -Column(1)) =1, Column(1))
what you are looking for (Note the minus in front of the first Column(1))?