Discussion board where members can get started with Qlik Sense.
Hello! I want to make calculable dimension, based on variable value. Formula is simple: =if(vVStarget='',1, Sv), vVStarget - variable.
But! In dimension field condition applies only after load script run. Meanwile in measure field, values updated every time when variable updates.
Example on picture. Variable is empty, but only in measure column presented actual calculation. Dimension column aupdates only if i;m ru load script. any way to mace dimension also update automaticly?
So, i've find out, that for dimension this formul must be like: =if(aggr($(vVS),[internal-id])='Выберите объект',1, Sv),
Where, internal-id - basic ID of element in my table
View solution in original post