topic Re: Highlight the max expression in chart in QlikView

Highlight the max expression in chart

Anonymous — Wed, 14 Jun 2017 05:00:54 GMT

Gud Mrng Everyone,

Today I wanted to highlight my max value in the bar chart with a different colour.

For which I had created a bar chart.

Dimension: if(Match(System_Created,'CLA','GOL','LOI','QUO','SES','BUL')

Expression : Count(GID3)-Count(DISTINCT GID3)

To highlighted Max bar, in another colour

Expression--Background Colour =If(Sum(Count(GID3)-Count(DISTINCT GID3)) = Max(Total Aggr(Sum(Count(GID3)-Count(DISTINCT GID3)),if(Match(System_Created,'CLA','GOL','LOI','QUO','SES','BUL'), RGB(245, 121,111), RGB(122,122,122)))))

Not getting the desired result, Can anyone help me Please?

Re: Highlight the max expression in chart

Anonymous — Wed, 14 Jun 2017 05:02:52 GMT

Dimension: if(Match(System_Created,'CLA','GOL','LOI','QUO','SES','BUL',System_Created)

Re: Highlight the max expression in chart

prma7799 — Wed, 14 Jun 2017 05:05:31 GMT

Can you please share sample app.

Re: Highlight the max expression in chart

Anil_Babu_Samineni — Wed, 14 Jun 2017 05:06:00 GMT

Do we expect any application from you to play around for BG color because you are using Calc. Dimension to do this? That would be better to help you

Re: Highlight the max expression in chart

Anonymous — Wed, 14 Jun 2017 05:17:00 GMT

Hi Anil,

As said before I didn't get the option to share my application. I even shared the snapshot with you.

Yes it is true I am using Calculated Dimension: if(Match(System_Created,'CLA','GOL','LOI','QUO','SES','BUL', System_Created)

In Expression I had used : Duplicate Count

And in Back Ground Color I want: if the Duplicate count is max then change into red else colour remain same.

Re: Highlight the max expression in chart

Anil_Babu_Samineni — Wed, 14 Jun 2017 05:23:58 GMT

once you reply to anyone from this thread, You will get "Use Advanced Editor" in the right corner top of your body message. Then bottom you will get "Attach". There you can and "Add Reply" then we can easy to access

Re: Highlight the max expression in chart

Anonymous — Wed, 14 Jun 2017 05:30:24 GMT

I have click on reply button still I didn't get the Advance Editor button.

Re: Highlight the max expression in chart

Anil_Babu_Samineni — Wed, 14 Jun 2017 05:33:06 GMT

Uploading a Sample

Re: Highlight the max expression in chart

Anonymous — Wed, 14 Jun 2017 05:36:47 GMT

Please find the required app

Re: Highlight the max expression in chart

Anonymous — Wed, 14 Jun 2017 05:38:54 GMT

Please don't share the app as I am not using a licence version.

Just need the Expression that I would use in Background Colour of Expression.

Re: Highlight the max expression in chart

Anil_Babu_Samineni — Wed, 14 Jun 2017 06:10:19 GMT

May be this?

If((Count(GID3)-Count(DISTINCT GID3))/Count(GID3) = Max(TOTAL Aggr((Count(GID3)-Count(DISTINCT GID3))/Count(GID3),Month1)), Green())

Re: Highlight the max expression in chart

Anonymous — Wed, 14 Jun 2017 06:15:41 GMT

Thanks, Anil

Re: Highlight the max expression in chart

passionate — Wed, 14 Jun 2017 06:20:10 GMT

You can even try using:

if(Rank(Count(GID3)-Count(DISTINCT GID3))=1,Green())

In Background color of your expression

Re: Highlight the max expression in chart

Anil_Babu_Samineni — Wed, 14 Jun 2017 06:31:12 GMT

Some cases this won't work, I've tried many times this? But good idea