Hide / Show a column of a Table

[hector_jvb]

Hello,

I have a simple table where I want certain columns are hidden and appear to select certain data, and to achieve that if this July selected appears and if any other month is selected to be hidden, the problem I have is that when you chose the months of June and August when the column appears should be hidden since the month of July is not selected, someone could help me? please.

Add images try to explain the above.

[tamilarasu · Accepted solution]

Hi Hector,

You can use below expressions in conditonal option in expression tab.

Total_Ejercido_Junio

=If(Wildmatch(GetFieldSelections( Month ,'|' ,12), '*Junio*'),1,0)

Total_Ejercido_Julio

=If(Wildmatch(GetFieldSelections( Month ,'|' ,12), '*Julio*'),1,0)

Total_Ejercido_Agosto

=If(Wildmatch(GetFieldSelections( Month ,'|' ,12), '*Agosto*'),1,0)

[hector_jvb]

Hello Tamil Nagaraj,

Thank you so much for your help, the conditions helped me and I could solve my problem.

[hector_jvb]

Hello,

Now I need you to have selected a month and year column is hidden.

Add pictures of what I require to do.

[tamilarasu]

Hello Hector,

Total_Ejercido_Julio_2016

If(Wildmatch(GetFieldSelections(AND),'*2016*') And Wildmatch(Getfieldselections(MES2 ,'|' ,12),'*Julio*') ,1,0)

Total_Ejercido_Julio_2015

If(Wildmatch(GetFieldSelections(AND),'*2015*') And Wildmatch(Getfieldselections(MES2 ,'|' ,12),'*Julio*') ,1,0)

I am not sure how many expressions you have in your table. If a new month or a year data is added, you have to create a new expression everytime. It will make the maintenance a bit complicated.

Let me know if the above expressions fulfills your need.

[hector_jvb]

Hello Tamil Nagaraj,

The expressions make a mistake.

Shipping image to show where marks the mistake.

Greetings.

[tamilarasu]

Hi Hector,

I mentioned the year field name as "AND" by mistake. I was not able to type the letter "Ñ" (Copied from Google translator ) in my keyboard.

If(Wildmatch(GetFieldSelections(AND),'*2016*') And Wildmatch(Getfieldselections(MES2 ,'|' ,12),'*Julio*') ,1,0)

If(Wildmatch(GetFieldSelections(AÑO),'*2016*') And Wildmatch(Getfieldselections(MES2 ,'|' ,12),'*Julio*') ,1,0)

You need to change AND to AÑO in your year field.

[hector_jvb]

Hello Tamil Nagaraj,

Again thank you very much for your help, conditions helped me and I could solve my problem.