Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a Block chart with two Cyclic groups conditionally enabled so that only one will be enabled based on a condition.
To my surprise, if the expression returns no value, both the Groups are coming up.
If it has data, it works fine.
It also works as expected for other charts.
Cheers,
Naresh
Change the condition in dimension tab
For New Group
GetFieldSelections(Test)=1
For New Group1
GetFieldSelections(Test)=2
Also in your example there is no value for Stock... You can change to Sum(Sales) as an expression
Thanks Manish.
Issue occurs only when there is no value.
If I change it to Sum(Sales), there's no issue.
And it doesn't work even when GetFieldSelections(Test)=1 or 2
Cheers,
Naresh
use this..
Hi Naresh,
I think it is a bug, the workaround is place text object on top of the cyclic groups and show/hide the text object conditionally.
Regards,
Jagan.
Still it doesn't work for Stock
It will not work if you don't have any values... because in block chart you don't have option of Suppress Zero Values..
Hi,
Looking at your attached file. Your script don't have value for Stocks, populate Stocks in the script reload and your expression will work. With the Enable Conditions (Dimensions) for value in Field Test, use this
if(GetFieldSelections(Test)=1,1,0) // For Test = 1
if(GetFieldSelections(Test)=2,1,0) // For Test = 2
This should get you what you want.
Find attached
Hi Gabriel,
That's where I started. My Stock has no value and only then this issue arises. For example, there is no stock and so I can't populate stock.
My very first question says
" To my surprise, if the expression returns no value, both the Groups are coming up."