topic IF statement trouble in App Development

IF statement trouble

DanielAndress — Tue, 15 Nov 2022 17:07:18 GMT

Hi,

The problem I am trying to solve is using an IF statement to create a dimension that allocates products to catagory types (footwear if categoryID is 5 or 6, or Clothing if any other ID) based on CatagoryID.

It's coming up with the catagories however there is also an extra grey colum and i am stuck on what to do. Thank you.

Re: IF statement trouble

barnabyd — Tue, 15 Nov 2022 20:49:58 GMT

G'day @DanielAndress,

The grey column represents all the data rows that don't have a value for CategoryID. If you don't want it to appear, then go to the properties of your chart and under the Category Type dimension, uncheck "Include null values".

Cheers, Barnaby.

Re: IF statement trouble

BrunPierre — Wed, 16 Nov 2022 09:45:47 GMT

As an alternative, you might prefer to use an expression filter. By doing this, the chart will only show the desired labels.

Sum({<CategoryID={5,6}>}Sales)