Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have created an drill down group with 3-fields and created an bar chart.
Now we need to coloured 3-dimensions with in group dynamically based on selection.
Ex: Group=Year+Quarter+Month
Year = red()
Quarter = blue()
Month= yellow()
We have used '=If(GetCurrentField(Group) = 'Period', Red(), Blue()) ' this logic but it works for 2-fields with in a group.If we add another colour the logic won't work.
Thanks..
Hi,
Try,
=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))
did u try this?
'=If(GetCurrentField(Group) >3 Red(), Blue()),yellow() '
'=If(GetCurrentField(Group) > 'Period', Red(), Blue(),yellow()) '
Hi Chanty,
It won't work.
Thanks
Hi,
Try,
=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))
Hi Nagraj,
It gives colour for 2-dimensions but not for all 3-dim...
Thanks..
can u share a sample?
try to check the name of your fields and group name
=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))
and post your example, please
sorry i can't share an application.
Scenario: My drill down group has 3-dimensions
EX: Year,Quarter,Month
Expression: sum(sales)
Chart used: Bar
Requirement: Year = red,quarter=blue,moth=green.
Current result after using '=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))'
Year=red,quarter=blue,month=blue
Not able to capture month=green
Thanks..
Hi Naresh
Can you please share your QVQ file.
Regards
Kushal Thakral
so, what is name of your drill down group?