Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having issues with in Qlkiview into what calculation I will need to do.
=max( aggr( count([DATE]), Stock))/ sum (Stock)
This will return the values I will need, for example 0.7, or 0.65, however, I need that calculation, but to work out how to return the results that will be less than 1.
May be this
Sum(Aggr(
If(Max(Aggr(Count([DATE]), Stock))/Sum(Stock) < 1, 1, 0)
, Piece))
could you please explain better what number are you looking for?
It is not I am looking for a number. The calculation should count how many are less than 1.
=max( aggr( count([DATE]), Stock))/ sum (Stock)
This calculation will return different values such as 0.7, or even 10. But I want that same calculation, but with where it also calculates how many are less than 1.
If you seen from the image file, there is a column where you can 0.7.
However, the column should count how many are less than 1. In that picture it should return 1 as there is only one result. If there were 10 results with 0.7, then it will return 10. If there were 5 with 1.2, then it should return 0.
May be this
Sum(Aggr(
If(Max(Aggr(Count([DATE]), Stock))/Sum(Stock) < 1, 1, 0)
, Piece))
Sunny,
Thank you so much! I believe it is working now.
Thanks,
Chin_IT
Sunny,
How will it be if I were to use the calculation below?
Count([DATE])/Sum(Stock)
Not sure I follow your question?
It is what you did for me last time, but for a different calculation
count([DATE])/Sum(Stock)
I want to find the values that are less than 1, and it will return a 0 if false, and a 1 if true
May be this
Sum(Aggr(
If(Count([DATE])/Sum(Stock) < 1, 1, 0)
, Piece))