Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

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
Highlighted
Partner
Partner

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

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