Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using the below I can get field selected in Field from State1, just wondering can I make State1 dynamic (eg, last few digits from a parameter $1). I have tried with replace($1,’is’,’’). But seems like qlikview can not recognize it. Have anyone tried this out before?
can you upload a sample application for better resolution of your issue. ?
I have created a variable vtest as Replace($1,'is','') and then using a text object =$(vtest('isAcutal'))
and it is working fine.
Hi Ronald,
You can try to create a variable to hold the state name with the parameter and then use that variable in your expression for the state name
vStateName = 'State'$1
HTH
Sushil
Thanks Sushi,
I also want to include the above function into my variable, so basically I will past a value to $1 of that variable, and then certain component of the $1 value is what I want to use in state1. say for example the value past to $1 is 'isActual' then I want to use Actual as the state name. I have try replace($1,'is',''). but not getting the result I want
can you upload a sample application for better resolution of your issue. ?
I have created a variable vtest as Replace($1,'is','') and then using a text object =$(vtest('isAcutal'))
and it is working fine.
Ensure that you should not use equal (=) sign while creating the variable definition