Discussion Board for collaboration on QlikView Layout & Visualizations.
I have this data
And one aditional field named Val, with values:
I have a straight table with one calculated dimension
And one simple expression
The idea is that the results are displayed depending on the selection on Val field. But where such selection is made, the results are not as expected. for example, when the value is 20.
But, if change the dimension to a hard-coded value, e.g. If(Aggr(Sum(Valor),Vendedor)<=20,Vendedor), it works fine.
Thanks in advance.
Go to Solution.
Try this as your calculated dimension:
If(Aggr(Sum(Valor),Vendedor) <= Aggr(Only(Val), Vendedor), Vendedor)
another option is using min/max, that one regardless if you have a selection or not it will always give you a default value
Thank you so much.
I am glad we were able to help.
Thanks in advance Ramon!