Hide entire line items if its 0 from Gallery

[nagaraj007]

Hello All,

I would like to hide entire line items if the data is 0 in any of the 2 years selected (it may be Qty of 2013 or Qty of 2017 or Value of 2013 or Value of 2017) from the gallery. Please advise how to go about it.

Attached is the image for reference.

[rubin_boer]

hi @nagaraj007 

Filter the data will help... Filter(datasource, Or(qty > 0, Value >0)) you can further include the years but seeing you only hav two years that should do it.

Hope it helps

[nagaraj007]

Hi Rubin,

I am getting the attached error. Please advise

[nagaraj007]

I have added the formula in main gallery filter and i get this error. Please advise.

[nagaraj007 · Accepted solution]

Hello All,

Its very urgent and we would like to filter the data, please advise.

[rubin_boer]

hi @nagaraj007 you will use Or when there is more than one column you wish to filter. In your case Filter(Gallery3_2.AllITems,'qty from year' > 0)

 if not a value change 'qty from year' to Value('qty from year')

hope this helps

[rubin_boer]

hi @nagaraj007 there are a few errors here:

Your filter is something like this: 

Filter(MyCombinedTable, 

Year >= 'from year_2'.Selected.Result, 

Year <= 'to year_2'.Selected.Result, 

'Membership Category' = memcategory.Selected.Result, 

Value('qty from_year'.Text) > 0)

Your group is by company name

GroupBy(

Filter(MyCombinedTable, 

Year >= 'from year_2'.Selected.Result, 

Year <= 'to year_2'.Selected.Result, 

'Membership Category' = memcategory.Selected.Result, 

Value('qty from_year'.Text) > 0), "Company Name", "Membership Np", "Membership Category"

, "grpcomp")

Sort By Columns

SortByColumns(

GroupBy(

Filter(MyCombinedTable, 

Year >= 'from year_2'.Selected.Result, 

Year <= 'to year_2'.Selected.Result, 

'Membership Category' = memcategory.Selected.Result, 

Value('qty from_year'.Text) > 0), "Company Name", "Membership Np", "Membership Category"

, "grpcomp"),

"Company Name" ,Ascending)

[nagaraj007]

Hi @rubin_boer ,

I am still getting the error message. Please find the attached screen snip

[rubin_boer]

hi @nagaraj007 please remove the .Text so you have Value('qty from_year')

[nagaraj007]

Hi @rubin_boer ,

I am getting lot of errors now. Please advise. Attached is the screen snip for your reference.