Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Visual Cues based on % Change

Hi,

I am using QlikView 11, and need to change the colour of a cell based on the improvement/decline of a customers sales month on month. I've created my chart with Jan, Feb, Mar and Apr

For example, Jan was £1,548, Feb was £747, Mar was £1,160 and Apr was £1,325. The targets set are that Feb needs to be 10% more than Jan, Mar needs to be 10% more than Feb and Apr needs to be 10% more than Mar. If it isn't, go red, if it is go green.

Any help is appreciated.

Regards

David

3 Replies
vvira1316
Specialist II
Specialist II

Hi,

LOAD * INLINE [
Month, Amt
Jan, 1548
Feb, 747
Mar, 1160
Apr, 1325
]
;

ThresholdColor.PNG

Row # Column

=RowNo(TOTAL)

Diff Column

=If(RowNo(TOTAL) > 1, If(Above(TOTAL Amt,1) > 0, Num((Amt-Above(TOTAL Amt,1))*100/Above(TOTAL Amt,1), '#.##')))

TextColor.PNG

=If(Num((Amt-Above(TOTAL Amt,1))*100/Above(TOTAL Amt,1), '#.##') < 10, RGB(255,0,0), RGB(0,255,0))

Anonymous
Not applicable
Author

Hi,

I'm calculating the totals using expressions, like this..

Sum (if (InMonth (Date, Today(), -3), [Sales Revenue])) then -2, -1 etc. to give me the sales for the previous months.

Where would I put the coding for this?

Regards

David

vvira1316
Specialist II
Specialist II

Hi David,

It will be difficult to provide any guidance without having your sample QVW file and complete understanding of data model. Share the file if you can.

I think you can utilize some sort of set analysis to achieve it.

Regards,

Vijay