topic Re: Chart functionality in QlikView

Chart functionality

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a query. I have column chart. When I select one of the element of it (Ex. Y axis has month Jan to Dec). When I select one of the month, rest months get invisible. only one month bar column shows. do we have option that if we select any bar , rest should be visible but in deactivated format. As in filter we select any value unavailable shows in Grey background.

Thanks in advance.

Re: Chart functionality

Anonymous — Wed, 25 Jan 2017 08:04:06 GMT

Hi Narendra ,

set the below expression to background color ,

if(isnull(only([Field name])) ,ARGB(20,200,200,200),ARGB(190,43, 123, 70)).

Regards,

Murali Mohan.T

Re: Chart functionality

Wed, 25 Jan 2017 08:13:58 GMT

Hi All,

I think I am unable to explain correctly. Please find following images.

* This is my Qlikview chart.

* When I click on "b" column bar. It look like this.

* I want chart like this.

Please help on this.

Re: Chart functionality

jonathandienst — Wed, 25 Jan 2017 08:25:59 GMT

You have to:

Modify the expression so it is not affected by the month selection. Add/modify Month= to a set expression.
Create a conditional background colour expression for the bars. Something like:

=If(WildMatch(GetFieldSelections(Month), Month), RGB(180, 180, 180))

This assumes the chart dimension is a field named "Month". Adapt this to your specific requirements.

If you need more specific help, you will need to provide more details, such as the dimension and expression of the chart, or better still, a small qvw containing sample data and the chart you would like to modify.

Re: Chart functionality

Wed, 25 Jan 2017 08:35:35 GMT

hi, I tried it. but does not work. showing same result.

Re: Chart functionality

MK_QSL — Wed, 25 Jan 2017 08:43:44 GMT

I have considered that your bar chart is having below

Dimension

InvoiceMonth

Expression

SUM(Sales)

To achieve your requirements..

Use Expression as below

SUM({<InvoiceMonth>}Sales)

Use below as Expression background color..

IF(GetSelectedCount(InvoiceMonth)<>0,

IF(InvoiceMonth = GetFieldSelections(InvoiceMonth),Green(),LightGray()))

If you want to show multi color when no month is selected, go to colors tab and Tick Multicolored.

Note : Change your field name and expression accordingly.

Hope this is what you are looking for..

Re: Chart functionality

MK_QSL — Wed, 25 Jan 2017 08:47:20 GMT

If you want multiple months selection and want to show all of them as green.. use as below

IF(GetSelectedCount(InvoiceMonth)<>0,

IF(SubStringCount(GetFieldSelections(InvoiceMonth),InvoiceMonth),Green(),LightGray()))

Re: Chart functionality

Wed, 25 Jan 2017 08:54:40 GMT

Hi All,

Please read question again.

I think I am unable to explain correctly. Please find following images.

* This is my Qlikview chart.

* When I click on "b" column bar. It look like this.

* I want chart like this.

Please help on this.

Re: Chart functionality

avinashelite — Wed, 25 Jan 2017 10:00:07 GMT

Try like this : Right Click on chart > Select Set Reference that should work in your case

Re: Chart functionality

avinashelite — Wed, 25 Jan 2017 10:04:55 GMT

Try like this : Right Click on chart > Select Set Reference that should work in your case

Re: Chart functionality

Anonymous — Wed, 25 Jan 2017 10:16:02 GMT

Hi narendra,

find the attachment, to meet ur requirement.

Regards,

Murali Mohan.T

Re: Chart functionality

Wed, 25 Jan 2017 10:41:11 GMT

Great work avinash!!!!

Thanks you very much

Re: Chart functionality

MK_QSL — Wed, 25 Jan 2017 10:51:47 GMT

If you follow my steps you will get this...

I don't think so you have tried my solution..

Re: Chart functionality

Wed, 25 Jan 2017 10:52:21 GMT

hi, 1 more query. can we change the color of deactivated columns after setting set reference?

Re: Chart functionality

MK_QSL — Wed, 25 Jan 2017 11:25:13 GMT

Check the attached file..

You can also check

Highlight QlikView Bar Chart based on Current Selections - YouTube

Highlighting bars on Chart

https://community.qlikview.com/thread/202089

Highlighting Bar Chart based on Current Selections

Re: Chart functionality

Wed, 25 Jan 2017 12:54:18 GMT

Thank you,

1 more query. I Set Reference to chart. it works as desired.

but when I reopen file ( even after saving) , Set Reference rules get vanish. Even If I do some activity ex. applying color to chart , it disabled the Set Reference.

do we have any trick to Set Reference available until I disable it?

Re: Chart functionality

MK_QSL — Wed, 25 Jan 2017 13:03:18 GMT

Have you used my answer????

Re: Chart functionality

Wed, 25 Jan 2017 13:27:53 GMT

I used answer of Avinash. About changing color of deactivated bars, when I use dark color to bars, deactivated bars can be easily identified. so I though we should not spend time on it.

would you please guide me on Set reference available every time. I mean until I disabled it.

Re: Chart functionality

MK_QSL — Wed, 25 Jan 2017 13:32:46 GMT

Wait for Avinash to come back on this...!

Re: Chart functionality

MarcoWedel — Wed, 25 Jan 2017 21:48:00 GMT

Hi,

maybe also helpful:

Line Chart tricks: Displaying what's important

Focus not Filter | Qlikview Cookbook

Search Recipes | Qlikview Cookbook

Re: scatter graph for the provided excel sheet

regards

Marco