How to hide a label when another label is showing

[Gana_Dube]

Hi, how can I hide a label if another label is showing.

I have the following scenario, case example 1, which is a progress bar, depending on the number of checkboxes selected, if the sum of all checkboxes is greater than a certain amount, show the progress percentage below. In this example, all checkboxes are selected, which means all the labels will show leading to 100%, this is done horizontally

I would like to implement scenario 2, whereby I only show the label percentages stacked depending on the number of checkboxes selected. So show the 80% label if 80% of the checkboxes are selected without showing the other labels. And likewise with the other labels.

The code I use for scenario 1 is: for the 20% label, if the value of the selected checkboxes is greater than 4, show the label, this method is done for the other checkboxes and toggles. Considering most inputs are Boolean values, the logic is all the same.

If(c2_c1_check1.Value +
c2_c1_check2.Value + 
c2_c1_check3.Value + 
c2_c1_check4.Value + 
c2_c1_check5.Value + 
c2_c1_check6.Value + 
c2_c1_check7.Value + 
c2_c1_check8.Value + 
c2_c2_check1.Value + 
c2_c2_check2.Value + 
If(c2_c2_check3.Value,1, c2_c2_check4.Value, 1, 0)+
c2_c3_check1.Value + 
If(c2_c3_check2.Value,1, c2_c3_check3.Value, 1, 0)+
If(c2_c4_toggle1.Value,1, c2_c4_toggle2.Value, 1,c2_c4_toggle3.Value, 1, c2_c4_toggle4.Value, 1,c2_c4_toggle5.Value, 1, 0) +
c2_c4_check1.Value + 
If(c2_c4_check2.Value,1, c2_c4_check3.Value, 1, c2_c4_check4.Value, 1, 0)+
c2_c7_check1.Value + 
c2_c7_check2.Value + 
c2_c7_check3.Value + 
c2_c7_check4.Value + 
If(c2_c7_check5.Value,1, c2_c7_check6.Value, 1, c2_c7_check7.Value, 1, 0) > 4, true, false)

[iAm_ManCat · Accepted solution]

Heya,

Why not just have one label whose Text value changes based on the number of checked boxes? That way you also only have to write one formula instead of a formula for each label

So you'd have the text property add up the values, divide by the total number of potential answers, then times by 100 to get a percent.

I have included a sample app here that you can open to see how it can be done,

Cheers,

Sancho

[Gana_Dube]

@iAm_ManCat Thank you very much 🙂 your solution was perfect and the code example was excellent. This was very efficient.

[iAm_ManCat]

Happy to help, hope you have a great day 🙂