Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

Conditional dimension, based on variable: "if" reacts only after reload

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?

a0a9b2ccde.jpg

1 Solution

Accepted Solutions
evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

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

1 Reply
evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

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