topic Re: advanced bar chart in QlikView

advanced bar chart

Anonymous — Thu, 14 May 2015 16:59:50 GMT

Hi everyone,

i want to calculate attendence of an employee for a month ,with Weekname as my dimension and his sum(attendance) as expression , but the problem is i want to show all the employees who are having attendance less than 3 days for that particular week as below the axes..just like when we are plotting graph .

thanks in advance

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 17:02:24 GMT

All you need to do is to make the result negative if the attendance <=3. For example:

if(sum(Attendance)>3, sum(Attendance), -sum(Attendance))

Re: advanced bar chart

ramoncova06 — Thu, 14 May 2015 17:08:43 GMT

see if this is what you are looking for

sum({< employee= {"$(=sum(attendance) < 3)"}>}attendance)

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 17:41:06 GMT

i want to show color in green and red

if(sum(sales)>15, sum(sales), Green(),

if(sum(sales)<15,-sum(sales),blue()))

this expression is not working pls help

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 17:47:46 GMT

To define color, you have to use "Background Color" expression, not the "main" expression itself which stays as is.. Click on the "+" sign at the expression name to see it. The color background expression will be:

if(sum(sales)>15, green(), blue())

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 17:59:02 GMT

i dont want the minus signs on red bars , what to do ??

Re: advanced bar chart

maxgro — Thu, 14 May 2015 18:16:53 GMT

try to hide the negative numbers with text color (replace column(1) if needed with your exp)

if(column(1)<=0,argb(0,0,0,0),black())

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 18:20:56 GMT

I'm not sure if it is possible. In general, I'd rather use a clearer presentation. Instead of showing the <=15 sales below the axes, I'd use a "normal" expression

sum(Sales)

But I'd add a reference line =15. So, the lower numbers will be at or below the reference line. In my example here the ref line is 100:

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 18:24:49 GMT

i used the same expression i see no values on red bars ,, and could you please why you used column there ,, wht was the logic ?

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 18:33:46 GMT

To get rid of the minus for the bars below the line add another expression of say Sum (Value) and for it untick Bar and tick Value in Data Points

Rough mock up qvw attached.

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 18:51:10 GMT

yup its working , please do share things like this to my mail if possible

qvhelpplease@gmail.com

Re: advanced bar chart

Anonymous — Thu, 14 May 2015 18:52:37 GMT

this is was informative and really cool , please do mail possible suggestions to my mail

qvhelpplease@gmail.com

thanks