# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Did you mean:
Contributor II

## Hide / Show a column of a Table

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.

1 Solution

Accepted Solutions
MVP

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)

7 Replies
MVP

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)

Contributor II
Author

Hello Tamil Nagaraj,

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

Contributor II
Author

Hello,

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

Add pictures of what I require to do.

MVP

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.

Contributor II
Author

Hello Tamil Nagaraj,

The expressions make a mistake.

Shipping image to show where marks the mistake.

Greetings.

MVP

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.

Contributor II
Author

Hello Tamil Nagaraj,

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