Current Value of ValueLoop

Anonymous — Tue, 24 Oct 2017 14:35:19 GMT

Hi All, I want the current value of the valueloop function when a condition doesnt match. Here is my scenario:

I am trying to colour the graph(in line chart) based on current month value. If the months are greater than current month, i want to show a in grey. Further, I have some missing months in my data. Here is an example of my data:

Acnt Month Sales

A1 Jan 23

A1 Feb 20

A1 Jul 30

A1 Nov 50

I have a requirement to plot missing months with sales values value as 0. I have already achieved this by using Value loop function -

sum(if(ValueLoop(1,12)=[Month No], Sales, 0))

However, While I am trying to colour the graph(Expression>Background Colour), I am having issue. I think If I can get the current value of the value loop function which dont match with the Month Number, I can colour the graph per my need

Please advise.

Thanks

Samy

topic Current Value of ValueLoop in QlikView

Current Value of ValueLoop