topic Re: Data load editor expression in App Development

Data load editor expression

Anonymous — Wed, 14 Nov 2018 23:19:45 GMT

Do you know how to modify this set analysis expression, so it will work in the Data Load Editor instead?

If(Sum({$<CategoryName={

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear'

}>}Sales)

= 0,'',Sum({$<CategoryName={

'Womens wear',

'Sportwear',

'Bath Clothes',

'Ladies´Footwear',

'Children´s wear',

'Babywear'

}>}Sales)

)

Here is the data

CategoryName	Sales
Men´s Clothes	-$5,809.44
Womens wear	$394.13
Womens wear	$1,308.29
Womens wear	$1,842.34
Womens wear	$5,809.44
Womens wear	$9,035.75
Sportwear	$1,308.29
Sportwear	$9,035.75
Sportwear	$5,809.44
Bath Clothes	$1,842.34
Ladies´Footwear	$1,308.29
Ladies´Footwear	$1,842.34
Children´s wear	$394.13
Babywear	$55.94
Babywear	$1,308.29
Babywear	$198.98
Men´s Clothes	-$476.50
Men´s Clothes	-$927.71

Here is the end result I want to create using the Data Load Editor

CategoryName	Sales
Totals	$41,494
Babywear	$1,563
Bath Clothes	$1,842
Children´s wear	$394
Ladies´Footwear	$3,151
Men´s Clothes
Sportwear	$16,153
Womens wear	$18,390

Re: Data load editor expression

Thiago_Justen_ — Thu, 15 Nov 2018 01:57:10 GMT

What about this:

Load
CategoryName,
If(Match (CategoryName,'Womens wear',
'Sportwear',
'Bath Clothes',
'Ladies´Footwear',
'Children´s wear',
'Babywear') and NumSum (Sales)>0, Sum(Sales)) as SumSales
From YourTable Group By CategoryName;

Or you could also try this:

Load
CategoryName,
Sum (Sales)
From YourTable Where Match (CategoryName,'Womens wear',
'Sportwear',
'Bath Clothes',
'Ladies´Footwear',
'Children´s wear',
'Babywear') Group By CategoryName;

Re: Data load editor expression

Anil_Babu_Samineni — Thu, 15 Nov 2018 03:54:35 GMT

As per your data, I don't think so - Why you have written that many lines. Create straight table with

Dimension - CategoryName

Measure - Sum(Sales)

If you want to restrict only these categories do this way?

Sum({<CategoryName = {'Babywear', 'Bath Clothes', 'Children´s wear', 'Ladies´Footwear',
'Men´s Clothes', 'Sportwear', 'Womens wear'}>} Sales)