topic Re: barchart in QlikView

barchart

Wed, 16 Apr 2014 06:22:35 GMT

Hi all

i wanted to show the bar chart as below

here selected bars are showing as blue non selected bars are showing as Gray

Is it possible

Re: barchart

Wed, 16 Apr 2014 06:25:21 GMT

In QlikView , if u are selecting particular bars then it will display those much of bars only.

It will not display other bars as gray.

Correct me if my understanding is wrong.

Re: barchart

linusblomberg — Wed, 16 Apr 2014 06:32:12 GMT

Yes it is possible. I don't have my example right now but you can enter the color under background color when you expand the expression. Use an if-case, if(expression, red(),gray())

Hope this helps

Re: barchart

MK_QSL — Wed, 16 Apr 2014 06:35:47 GMT

Please check enclosed file..

Re: barchart

Wed, 16 Apr 2014 07:31:47 GMT

Hi Manish Kahhia,

Thank for your reply

could you please explain the bellow expressions

SUM({1}Sales)

IF(Match(Customer,Only({A} Customer)),BLUE(),RGB(179,179,179))

Re: barchart

arjunkrishnan — Wed, 16 Apr 2014 07:34:06 GMT

Hai Reddy ,

Try This One on You Background Color in Expression It Working Fine

=IF(MonthYear=Only(MonthYear),Blue(),RGB(179,179,179))

Re: barchart

Wed, 16 Apr 2014 07:39:33 GMT

if i am nothing is selected in the customer field but the chart will show like all the fields are selected .. is it wright...

Re: barchart

MK_QSL — Wed, 16 Apr 2014 08:09:03 GMT

Here A is an Alternate State...

But obviously you can use the same without alternate state.

SUM({1}Sales) This will give you total sale by Customer/Year and even though you select any year or customer, your all bar will be visible because {1} is freezing all bars...

Try SUM(Sales) and SUM({1}Sales) with two different bar chart and select any customer, you will realize what is happening.

IF(Match(Customer,Only({A} Customer)),BLUE(),RGB(179,179,179))

IF(Match(Customer,Only(Customer)),BLUE(),RGB(179,179,179))

Here

Match(Customer, Only(Customer) is matching 1st Parameter Customer with 2nd parameter Only(Customer)

If Match is successful IF will execute the BLUE() and not successful RGB(179,179,179)..

Hope this helps...

Re: barchart

linusblomberg — Wed, 16 Apr 2014 08:27:25 GMT

Some of the examples here are a little more complicated than they need to be. I personally prefer Arjun Krish example. If you want more than one month to be highlighted I would use a min and max date variable (I always define the min and max-date variable)

if(YearMonth>=$(vMinYearMonth) and YearMonth<=$(vMaxYearMonth),red())