Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an issue where I am looking at the union of two sets, both stipulated within the same expression, and filters are only being applied to the first part of the union.
I've attached an example with 2 version of set analysis, both producing weird results. When selecting any ID that is not 'E' I would expect the bottom two tables to match the top table, and exclude any count for 'E'. The filter is only applying to the first part of the Union.
I've changed the extension for the attached file, please change it back to .qvw and it should work. We can't attached .qvw's anymore?
Try like this
sum( {< ID -= {'E'} > + < ID *= {'E'} ,Year -= {'2001'} >} Amount)
BTW very smart way to share your qvw 🙂
Try like this
sum( {< ID -= {'E'} > + < ID *= {'E'} ,Year -= {'2001'} >} Amount)
BTW very smart way to share your qvw 🙂
{< ID -= {'E'} > + < ID *= {'E'} ,Year -= {'2001'} >} Amount)
Hi sunny,
What does the Star indicate in the set analysis?
Thanks
Nithin
Look here on information about *
Awesome thanks Sunny, and very useful reading too 🙂