topic Re: Color consistency in QlikView

Color consistency

Tue, 27 Aug 2013 10:29:08 GMT

Hi,

I have a chart wherein I have made the data in it remain consistent irrespective of the selection made on year,month and quarter.

I have also specified the background colors that has to displayed for different risk levels and it seems to work fine.But,the issue is that when there is no data pertaining to a year (in my eg 2010 and 2012)the data remains consitent but the color of the graph changes.I have attached the application that I have been working on.Please provide the solution for this issue by making the colrs remain consistent irrespective of the selections being made

Re: Color consistency

MayilVahanan — Tue, 27 Aug 2013 10:40:14 GMT

Try like this

if(Only({1}Risk_Level)='1-Very High',RGB(255, 0, 0),

if(Only({1}Risk_Level)='2-High' ,RGB(171, 233, 198),

if(Only({1}Risk_Level)='3-Medium', RGB(255, 217, 47),

if(Only({1}Risk_Level)='5-Very Low', RGB(130, 200, 200),

RGB(80, 160, 240)))))

Re: Color consistency

Anonymous — Tue, 27 Aug 2013 10:56:01 GMT

Hi,

above one also correct other wise

Re: Color consistency

Anonymous — Tue, 27 Aug 2013 10:59:55 GMT

Hi anushree,

above one also correct other wise you can chenge the color in object colors tab also it will work.........

Please find the attachemnt of your application.

Regards

Re: Color consistency

Tue, 27 Aug 2013 11:02:17 GMT

Thanks Mayil the solution given,is exactly what I needed.Can you Please let me know the functionality of only() as to when and where they would be used

Re: Color consistency

MayilVahanan — Tue, 27 Aug 2013 11:08:26 GMT

From Help"

If expression or field iterated over the chart dimension(s) contain one single value, that value is returned, else NULL is returned.

Only can return numeric values as well as text values.

You can use only() function that occur only one time.

Only(Risk Level]) is similar to [Risk Level]. We can use set analysis in only() function

Re: Color consistency

Tue, 27 Aug 2013 11:08:51 GMT

Hi Khadar,

I am not seeing any attachment here

Re: Re: Color consistency

Anonymous — Tue, 27 Aug 2013 11:11:51 GMT

Hi Anushree,

please find the attachment of application.

Regards