topic Need Help in QlikView

Need Help

Anonymous — Fri, 07 Apr 2017 14:22:23 GMT

Hi All,

Greetings,

I want to show % Change (this year vs last year) Positives values to be highlighted in Green and negatives in Red in horizontal bar chart. Can anyone help me.

Regards

Adarsh

Re: Need Help

sunny_talwar — Fri, 07 Apr 2017 14:27:44 GMT

Would you be able to share a sample to show what you have?

Re: Need Help

Anonymous — Fri, 07 Apr 2017 14:32:36 GMT

here this is the chart..............on right side

Re: Need Help

neelamsaroha157 — Fri, 07 Apr 2017 14:48:30 GMT

If its about changing the color then you can use 'Background Color' option when you expand your expression and use calculation.

If((your_Calculation)>0, green(), Red()).

Re: Need Help

Anil_Babu_Samineni — Fri, 07 Apr 2017 16:49:07 GMT

What was the expression you defined for +ve and -ve values?

Re: Need Help

Anonymous — Sat, 08 Apr 2017 19:56:27 GMT

if(GetSelectedCount(Year)=0 and GetSelectedCount(Month)=0 ,

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=YearStart(Max([Invoice Date])))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name)),

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=Min([Invoice Date]))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))

)>0,RGB(77,167,65),RGB(255,113,113)..

I am trying this but it is not working

Re: Need Help

Anonymous — Sat, 08 Apr 2017 19:56:52 GMT

if(GetSelectedCount(Year)=0 and GetSelectedCount(Month)=0 ,

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=YearStart(Max([Invoice Date])))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(YearStart(Max([Invoice Date])),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name)),

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=Min([Invoice Date]))<=$(=Max([Invoice Date]))"}>}Customer_Name)-

Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))/

(Count( DISTINCT {< Year=,Month=, [Invoice Date] = {">=$(=AddYears(Min([Invoice Date]),-1))<=$(=AddYears(Max([Invoice Date]),-1))"}>}Customer_Name))

)>0,RGB(77,167,65),RGB(255,113,113)..

I am trying this but it is not working