topic Re: Multi coloured drilldown group in QlikView

Multi coloured drilldown group

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Multi coloured drilldown group

Chanty4u — Thu, 31 Mar 2016 04:51:02 GMT

did u try this?

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

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

Re: Multi coloured drilldown group

nareshthavidishetty — Thu, 31 Mar 2016 05:06:43 GMT

Hi Chanty,

It won't work.

Thanks

Re: Multi coloured drilldown group

tamilarasu — Thu, 31 Mar 2016 05:26:49 GMT

Hi,

Try,

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

Re: Multi coloured drilldown group

nareshthavidishetty — Thu, 31 Mar 2016 08:29:27 GMT

Hi Nagraj,

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

Thanks..

Re: Multi coloured drilldown group

Chanty4u — Thu, 31 Mar 2016 08:32:30 GMT

can u share a sample?

Re: Multi coloured drilldown group

t_chetirbok — Thu, 31 Mar 2016 08:50:04 GMT

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

Re: Multi coloured drilldown group

nareshthavidishetty — Thu, 31 Mar 2016 08:50:52 GMT

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

Re: Multi coloured drilldown group

kushalthakral — Thu, 31 Mar 2016 08:53:38 GMT

Hi Naresh

Can you please share your QVQ file.

Regards

Kushal Thakral

Re: Multi coloured drilldown group

t_chetirbok — Thu, 31 Mar 2016 08:54:50 GMT

so, what is name of your drill down group?

Re: Multi coloured drilldown group

nareshthavidishetty — Thu, 31 Mar 2016 08:58:47 GMT

Hi,

Group name:Year_Cat

Thanks..

Re: Multi coloured drilldown group

t_chetirbok — Thu, 31 Mar 2016 09:00:23 GMT

so, you should use

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

Re: Multi coloured drilldown group

tamilarasu — Thu, 31 Mar 2016 09:02:52 GMT

Try this

=If(GetCurrentField(Year_Cat)='Year',Red(),

If(GetCurrentField(Year_Cat)='Quarter', Blue(),

If(GetCurrentField(Year_Cat)='Month',Green()

)

Re: Multi coloured drilldown group

nareshthavidishetty — Thu, 31 Mar 2016 09:21:42 GMT

Hi,

Thanks you all .It worked.

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

as given by Nagaraj.

Thanks..

Re: Multi coloured drilldown group

Anonymous — Thu, 31 Mar 2016 09:23:26 GMT

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

Re: Multi coloured drilldown group

engishfaque — Thu, 31 Mar 2016 09:33:24 GMT

Dear Naresh,

Here is another efficient way,

=Pick(Match(GetCurrentField(GroupName), 'Year', 'Quarter', 'Month'), Red(), Blue(), Yellow())

Kind regards,

Ishfaque Ahmed