Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
hector_jvb
Contributor II
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
tamilarasu

Hi Hector,

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

Capture.PNG

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)

View solution in original post

7 Replies
tamilarasu

Hi Hector,

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

Capture.PNG

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)

View solution in original post

hector_jvb
Contributor II
Contributor II
Author

Hello Tamil Nagaraj,

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

hector_jvb
Contributor II
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.

Qlik5.png

Qlik6.png

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
Contributor II
Contributor II
Author

Hello Tamil Nagaraj,

The expressions make a mistake.

Shipping image to show where marks the mistake.

Greetings.

Qlik7.png

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
Contributor II
Contributor II
Author

Hello Tamil Nagaraj,

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