Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Hi,

Try,

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

View solution in original post

15 Replies
Highlighted
Champion III
Champion III

did u try this?

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

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

Highlighted
Creator III
Creator III

Hi Chanty,

It won't work.

Thanks

Highlighted

Hi,

Try,

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

View solution in original post

Highlighted
Creator III
Creator III

Hi Nagraj,

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

Thanks..

Highlighted
Champion III
Champion III

can u share a sample?

Highlighted
Specialist
Specialist

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

Highlighted
Creator III
Creator III

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

Highlighted
Creator III
Creator III

Hi Naresh

Can you please share your QVQ file.

Regards

Kushal Thakral

Highlighted
Specialist
Specialist

so, what is name of your drill down group?