topic Re: Visual Cues based on % Change in QlikView

Visual Cues based on % Change

Anonymous — Wed, 26 Apr 2017 15:53:38 GMT

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

Re: Visual Cues based on % Change

vvira1316 — Wed, 26 Apr 2017 22:29:55 GMT

Hi,

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

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), '#.##')))

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

Re: Visual Cues based on % Change

Anonymous — Thu, 27 Apr 2017 07:45:08 GMT

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

Re: Visual Cues based on % Change

vvira1316 — Thu, 27 Apr 2017 16:38:00 GMT

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