Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Can we detach a Textbox?
We can detach a Chart object instead of by passing the values but is it possible in case of textbox?
Regards,
Balraj
What is your expression in text box.. ?
if something like SUM(Sales), you can use SUM({1}Sales).....
detach is not possible in text box.
No you can't but you can use SET analysis for that like
Sum({1} Metrics)
You cannot detach text box but the expression inside can be made "not influenced" by selections (use set analysis)
Is their any short way to bye pass the values in set analysis, instead of writing multiples selections filters coding?
Hi Balraj,
You can detach text object by using ALTERNATE states too or you can use the above methods also.
To create Alternate states go to document properties and in General tab you will find the option.
Regards,
@vi
Will it work(SUM({1}Sales).....) like detach function?
If you want to bypass all dimensions that are available in data model then use {1}
Sum({1} Metrics)
Ex:-
Sum({1} YourExpresion)
but if you need particular dimension bypass then
Sum({<Year=, Products=>} YourExpresion)// in this only Year and Products will be bypass
Hello Avi,
As per my understanding I have used ALTERNATE state for comparative part?
Can I use it for objects to free them from selections?
Regards,
Balraj
Thanks Anand