Hiding table columns dynamiclly

[Former Member]

Hello experts.

I'm trying to build a wizard which presents a simple query, one of the steps of the wizard is letting the user choose which columns he wants to see in the table at the end (the table is connected to the query).

When I deploy the model, If i submit the query (the submit is an action of the input field in the input form), there is no affect to the columns chosen. If i skip the submit (with a button) i see only the columns which were chosen.

Is there a way to solve it? is there a way to solve it through the webapi and i can, how?

thankl you.

Motty

[Former Member · Accepted solution]

Hi Motty,

I think you can do this with a data store. You can store the bool values for the different columns and refer to the data store fields in the hidden property of each column.

If this doesn't work, check your version of Visual Composer. I know that this hidden property of VC only works with SPS10+ (I'm not sure maybe it is 11+), but I have the same issue in the end of 2006 and opened an oss message and this bug was fixed with a SPS about 10 or 11.

Best Regards,

Marcel

[Former Member · Accepted solution]

Hi marcel

I used a data store and i'm working with VC 7.0 sp14

[Former Member · Accepted solution]

Hi Motty,

can you post your model here (via export)? Then I will check it on my system. This must work as I have described it.

Best Regards,

Marcel

[Former Member · Accepted solution]

Well.

Unchecking the Dynamic port solve the problem.

thank you all for your efforts.

Motty.

[Former Member · Accepted solution]

Dear Motty,

I am sending a solution to see if I understood your question. If helps you I will post this as a Wiki.

'How user can choose columns displayed in a Visual Composer table'

1. In a Form add 'Checkboxes',as many as you want

Form:

CHECK1

CHECK2

CHECK3

2. Youe table would have the following columns

Table:

Column1

Column2

Column2

3. At Properties>General tab>Hidden of each Column drag Check1 to the formula stage and makes each different of 'true'. It will look like this:

#ID[ACAPV6]@CHECK1<>true

Repeat this for CHECK2 and CHECK3

4. At 'Visibility Condition' of your table drag your three checkboxes making them '==true' and using OR between them. This would hide your table when you first lauch your application:

#ID[+++++]@CHECK1==true OR #ID[++]@CHECK2==true OR #ID[++++]@BOOL3==true

Lauch your application and checkbox one or all to see how your columns are shown or not.

Kind Regards,

GilsonTeixeira

Consultant, SAP BI 7.0

[Former Member · Accepted solution]

With great intrest I have applied the above solution - works fine, but there seems to be a bug :

If you apply the conditions to a new table, with the default column order : no problem, correct column is hidden

However, when you have rearranged the columns, not the column with the condition applied is hidden, but the wrong one (read : the column that's now at the place where the columns initially were before rearranging).

Have you experienced this too?

Thanks,

Kevin

[Former Member · Accepted solution]

Hi Kevin,

I will simulate as you said and come back to you.

Regards,

Gilson

[Former Member · Accepted solution]

Hi Gilson,

any feedback on this?

thanks 🐵

[Former Member · Accepted solution]

Hi All,

I try a similar case for our project. In our case, we will let the user to add additional columns in chart, not hide.

I applied your steps and I am sure this solution can work also for adding new columns. I created 3 check boxes for each additional key figure. If Checkbox1 is not marked, it should be hidden.

I have problem during the formula. At Properties>General tab>Hidden when I write #ID[ACAC5N]@Checkbox1 , it hides the column when checkbox1 is ticked. Do you have any idea how to make the formula reverse. I try with If statement but it has not worked so far. Thanks in advance.

Gözde

[Former Member · Accepted solution]

Hi All,

I solved the problem in formula.

Now, I have another important issue. Do you know how can the result of the table effect the Chart dynamically?

Currently chart brings all the keyfigures, not only the selected ones.

I tried also to make a filtering on the keyfigure structure with WEPAPI but it didn't work. Do you know a way to let the user add new keyfigures dynamically.

BR

GY

[Former Member]

Dear Motty,

I made an application where users choose columns via a Drop-donw list. Something like: if you choose '301' VC shows you columns 1, 2 and 3, if you choose '201' VC shows columns 4, 5 and 6.

Tell me if by adapting this idea would help you at all and I describe it better.

Regards,

GilsonTeixeira