Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Multi coloured drilldown group

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..

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

Hi,

Try,

=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))

View solution in original post

15 Replies
Chanty4u
MVP
MVP

did u try this?

'=If(GetCurrentField(Group) >3 Red(), Blue()),yellow()  '

'=If(GetCurrentField(Group) > 'Period', Red(), Blue(),yellow())  '

nareshthavidishetty
Creator III
Creator III
Author

Hi Chanty,

It won't work.

Thanks

tamilarasu
Champion
Champion

Hi,

Try,

=If(GetCurrentField(GroupName)='Year',Red(),If(GetCurrentField(GroupName)='Quarter', Blue(),Green()))

nareshthavidishetty
Creator III
Creator III
Author

Hi Nagraj,

It gives colour for 2-dimensions but not for all 3-dim...

Thanks..

Chanty4u
MVP
MVP

can u share a sample?

t_chetirbok
Creator III
Creator III

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

nareshthavidishetty
Creator III
Creator III
Author

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..

kushalthakral
Creator III
Creator III

Hi Naresh

Can you please share your QVQ file.

Regards

Kushal Thakral

t_chetirbok
Creator III
Creator III

so, what is name of your drill down group?