Set Analysis Values

[bobbydave]

Hi there,

I have a value that is broken down in to 3 categories X, Y and Z. There are another of groups that will have the same categories.

I am creating a stacked bar chart and it should add the Values for each grouping. Right now, I am just concentrating on getting one group (Other) working with the correct values for Breakdown.

The value that appears that appear are totally different to what should appear.

I should be getting something like (from an excel sheet)

Group	Breakdown	Value
Other	X	74,000
Other	Y	0
Other	Z	11,000

but instead, I am getting

Group	Breakdown	Value
Other	X	962,000
Other	Y	26,000
Other	Z	143,000

My set analysis is:

sum({<Breakdown={'*X*', '*Y*', '*Z*'}, Grouping={'OTHER'}, Year={'2014'}, Month={'Jan'}>} Value)

Any chance someone knows what is wrong with this?

Help appreciated. Thanks

[terezagr]

Hi,

you can try :

sum({<Breakdown={"*X*", "*Y*", "*Z*"}, Grouping={'OTHER'}, Year={'2014'}, Month={'Jan'}>} Value)

[Anonymous]

couple of things to verify and correct as necessary:

1. Grouping is not same as Group

2. Other is not equal to OTHER.

From looking at the tables in your post, try this:

sum({<Breakdown={'*X*', '*Y*', '*Z*'}, Group={'Other'}, Year={'2014'}, Month={'Jan'}>} Value)

[agomes1971]

Hi,

Sum({$<Breakdown={'"*$(=X)*"','"*$(=Y)*"','"*$(=Z)*"'},Grouping={$(=Other)},Year={$(=2014)},Month={$(=Jan)}>}value)

try this...

[bobbydave]

This gives a blank $0 value with nothing returned

[bobbydave]

That's my bad. That was a typo.

Values are being returned but just incorrect values.

[bobbydave]

Returns the same values that I have.

[jagan]

Hi,

Attach Sample file then it would be easier to give solution.

Regards,

Jagan.

[rubenmarin]

Hi, set analysis seems ok, probably you need to double-check the data, you can add an expression like:

count({<Breakdown={"*X*","'*Y*", "*Z*"}, Grouping={'OTHER'}, Year={'2014'}, Month={'Jan'}>} Value)

This way you can check if the number of records in QV is equal to the number of records in Excel.

A sample data or qvw would be nice to check what's going on.

[bobbydave]

As you can see, Table 1 has data corresponding to Graph 1.

The Graph should show a Year on Year comparison. I've all months 2014 and Jan 2015 so really, I am for now comparing Jan 2014 and Jan 2015. But as you can see from the Fast Change, the value have decimal places??

As you can see, Table 2 has data corresponding to Graph 2. They more or less are a breakdown of Table 1. Values may be different but you get the idea.

This table breaks each group down (Breakdown). Again on Fast Change, these values are incorrect.

Any help appreciated.