I see data out there but it keeps being "no data to display" in my chart

[Anonymous]

Hi folks,

Really need some help here. I'm stucked..

I am trying to create a bar chart showing the total ShipQty of a certain group of products.

I have three fields there.

1. Date

2. PartNum, which contains a group of products named "ABC1, ABC2, ABC3,etc" 

3. SellingShipQty

In the expression box I put "if(PartNum='ABC*',sum(SellingShipQty)) and it returns "no data to display"....

BTW, I created another field indicating ABC group hoping to add a list box of all the items in that group but also failed.

The list box of ABC is empty without any data.

But in the other list box of PartNum, I can see there are "ABC1, ABC2, ABC3" listed in there.

I wrote the script as follows,

Table:

Load

Date,

PartNum,

If (PartNum='ABC*', PartNum) as ABC,

SellingShipQty;

SQL Select *

from Table;

[Nicole-Smith · Accepted solution]

Change your chart to:

if(PartNum like 'ABC*',sum(SellingShipQty))

Or even better (using set analysis):

sum({<PartNum={'ABC*'}>} SellingShipQty)

[Anonymous]

Thank you, Nicole the set analysis syntax works!!!

[Nicole-Smith]

Please mark the answer as correct so other people can find answers to similar problems

[Anonymous]

Thanks, Nicole!